[thelist] Fw: A Little Query Question

Peter Brunone (EasyListBox.com) peter at easylistbox.com
Fri Dec 2 16:32:14 CST 2005

There may be a better way, but how about

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
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!!!

More information about the thelist mailing list