Re: (OT) MSSQL - get records #n...n+10?
| From: | Frank M. Kromann | Date: | Thu, 14 Dec 2000 00:57:27 +0000 |
| Subject: | Re: (OT) MSSQL - get records #n...n+10? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-30227@lists.php.net to get a copy of this message | ||
You could use a SET ROWCOUNT 10 as the first statement in your query. This way you will only get the
first 10 rows of the result. You woyld need to adjust the WHERE clause of the next SQL statement to
get the next 10 rows.
- Frank
>Hi, just wondering, is there an easy way in MS-SQL to get records
>#n...#n+10 like mysql's limit keyword?
>
>Cheers,
>
>Gfunk
>
>http://www.gfunk007.com/
>