| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> Re: Best method to SELECT TOP n TO m of a table
"Will Clark" <reply_only_to_newsgroup_please_at_noone-lives-here.com> wrote in
message news:bo8c98$orc$1_at_hercules.btinternet.com...
> SELECT TOP 3 * FROM table WHERE
> id NOT IN (SELECT TOP 5 id FROM table ORDER BY id)
> ORDER BY id
>
> While this is ok for this (simple) query, it can get quite messy if the
> query is more complex.
Could you please post that more complicated query? Received on Tue Nov 04 2003 - 11:15:15 CST
 |
 |