[thelist] Fw: A Little Query Question
Brian Cummiskey
Brian at hondaswap.com
Fri Dec 2 16:46:36 CST 2005
Casey wrote:
> 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?
In mssql 2000, you don't. It doesn't return a row counter, so there's
no way to keep track. Can it be done, sure. one method has already
been posted. But, it's not clean..
There are class functions for pear that can mimic this with an odbc on
php though...
More information about the thelist
mailing list