Re: Best method to SELECT TOP n TO m of a table
From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Tue, 4 Nov 2003 09:15:15 -0800
Message-ID: <2iRpb.17$S23.269_at_news.oracle.com>
Date: Tue, 4 Nov 2003 09:15:15 -0800
Message-ID: <2iRpb.17$S23.269_at_news.oracle.com>
"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 - 18:15:15 CET