[thelist] A Little Query Question

[Casey]

Ok, good idea, but thinking it through, the sub query selects the top 20,
 then the main query selects the top 10 from the top 20 -- isn't that the
 same as selecting the top 10?

 But - you gave me an idea.  Is there a SELECT BOTTOM 10?  You could select
 the TOP 20 in the sub query, then select the BOTTOM 10 from that set.  That
 would give you rows 11-20, right?

 Casey

> ----- Original Message ----- 
> From: "Peter Brunone (EasyListBox.com)" <peter at easylistbox.com>
>
>
> There may be a better way, but how about
>
> "SELECT
> TOP 10 FROM (SELECT TOP 20 field1, field2 FROM table1 WHERE... ORDER BY
> field2) ORDER BY field1 "
>
> ?
>
>
> -----Original Message-----
>> From: thelist-bounces at lists.evolt.org On Behalf Of Casey
>>
>> If you wanted to return the top 15 rows from a table, you could say
>> "SELECT
>> TOP 10 FROM table WHERE..."
>>
>> How would you word the query if you wanted rows 11 to 20?
>>
>> (asp.net with MS SQL)
>>
>> Thanks Tim!!!
>>
>> Casey
>>
>>
>