[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