Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-04-11 : 07:18:47
|
Torgny writes "In MySQL it is possible to select data based on a limit (top) and an offset, like so:SELECT * FROM table LIMIT 1 OFFSET 10; What I want to do is print one record per page and navigate between pages back and forth, and preferably just keep track of the offset like in MySQL, but I assume that's impossible. How can I accomplish this in SQL Server without overloading the server with a whole bunch of queries per page-load?I am using PHP 4.3.1 as a script language for this particular project.I have SQL Server 2000 on a Windows 2000 Advanced Server with the most recent service packs (afaik)." |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
|
|
|
Select with offset and limit in SQL Server 