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-02-27 : 12:35:50
|
| Amy writes "How can I only return a certain number of rows from a sql query?I want to be able to display the first 50 on the page, then provide "Next 50" and "Previous 50" buttons for the user to page through the results without scrolling through hundreds on records on one page.Thanks,Amy" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-02-27 : 12:38:17
|
| search here for articles on "whats after top" and seperate ones on "paging"one or the other or both will help you on your way.Edited by - andrewmurphy on 02/27/2003 12:38:37 |
 |
|
|
simondeutsch
Aged Yak Warrior
547 Posts |
Posted - 2003-02-27 : 12:39:26
|
| You will probably need to manage this through code on your front end, which sounds like ASP. It sounds like you don't really want to limit the number of rows returned, only the number of rows displayed. And SQL Server doesn't handle displays on its own.Sarah Berger MCSD |
|
|
|
|
|
|
Restrict the number of results returned in a sql query