SQL to select a set of records
| From: | Herhuth, Ron | Date: | Thu, 05 Feb 2004 19:58:22 +0000 |
| Subject: | SQL to select a set of records | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-22739@lists.php.net to get a copy of this message | ||
I am trying to figure out how to bring back only a specific number of
records using a SQL statement in Microsoft SQL Server.
For example I know how to bring back the first x number of records from
the database:
SELECT Top x * FROM SQLTable
What I would like to do is to bring back only records 25-35 for example.
Is there a way to do this?
Thanks,
Ron