You can for instance insert the top 35 into a tmp table, then delete the top 10 with from-from in the temp table, and then finaly select the rest. Alternative you can select top with decending order form the temp table, but this depends on if you have an ordered set or not of course. Another possiblility is to define a cursor, and then travers N rows, in it, and then display N:th until the M:th rows, where N is low bondary and M your high bondary. I hope this gives you some insperation to spinn off with. -----Original Message----- From: Herhuth, Ron To: php-windows@lists.php.net Sent: 5-2-2004 20:58 Subject: SQL to select a set of records 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 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
