MSSQL Top Option in Query

From: Date: Mon, 16 Oct 2000 18:19:47 +0000
Subject: MSSQL Top Option in Query
Groups: php.windows 
Request: Send a blank email to php-windows+get-3274@lists.php.net to get a copy of this message
Hi, I was wondering if their is a similar command in MS SQL as I have found in MySQL. With MySQL, I use "SELECT * FROM blah start(5,10)" That would spit back 5 rows, starting at the 10th row. However, in MS SQL, I have to use the top attribute which spits back the top n rows. I want to be able to specify that second attribute of what row to start at. "SELECT top 5 FROM blah" doens't exactly get what I want. I'm trying to get the next n rows on n pages type thing on a page I'm developing. Any ideas. -Flint _________________________________________________ Flint Doungchak Net Solutions, LLC 840 Lawrence Street Eugene, OR 97401 flint@netsolutionsllc.com Voice +1 541 345-7087 Fax +1 541 485-5519 http://www.netsolutionsllc.com

« previous php.windows (#3274) next »