LIMIT in MSSQL
| From: | Matthew Beers | Date: | Tue, 22 Aug 2000 22:04:14 +0000 |
| Subject: | LIMIT in MSSQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2279@lists.php.net to get a copy of this message | ||
Does anyone have any ideas on how to structure a MSSQL sql statement
to mimic the functionality of the MySQL LIMIT clause?
I want to be able to do something like:
SELECT * FROM Table1 LIMIT 100, 10
but in MSSQL.
I know about SELECT TOP, but it only allows for the TOP N records and
I want to find information further in the recordset arbitrarily. There
isn't an identity field that could be used for ordering either.
Thanks,
Matt