Re: Best method to SELECT TOP n TO m of a table
From: Will Clark <reply_only_to_newsgroup_please_at_noone-lives-here.com>
Date: Wed, 5 Nov 2003 12:11:19 +0000 (UTC)
Message-ID: <boapd7$30v$1_at_titan.btinternet.com>
Date: Wed, 5 Nov 2003 12:11:19 +0000 (UTC)
Message-ID: <boapd7$30v$1_at_titan.btinternet.com>
>
> SELECT TOP 3 id FROM
> (SELECT TOP 5+3 id FROM tblTwo WHERE
> fieldA = 'value' AND
> fieldB = 'value' AND
> (fieldC = 'value' OR fieldD =
> 'value')
> ORDER BY id)
> ORDER BY id DESC
>
Thanks for that Mikito, I'll try it out! Received on Wed Nov 05 2003 - 13:11:19 CET