[thelist] Fw: A Little Query Question

[Peter Brunone (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