Re: Best method to SELECT TOP n TO m of a table

>
> 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 - 06:11:19 CST