MSSQL Top Option in Query
| From: | Flint Doungchak | 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