limit for MSSQL
| From: | Foong | Date: | Tue, 08 Apr 2003 08:52:03 +0000 |
| Subject: | limit for MSSQL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-142820@lists.php.net to get a copy of this message | ||
Hello,
The following SQL does not work in MSSQL:
select * from table limit 20, 50
The TOP # in MSSQL doesn't alow me specify which starting record to
retrieve, only how many record to retrieve..
Anyone has solve this kind of problem before?
Foong