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 - 2005-08-26 : 08:12:38
|
| Ariston Collander writes "I have a table of data against which I need to run a very picky SELECT statement. What I need to do is limit the number of records returned so they can be put on a page in a "paged" format. For example: Let's say I have 55 records in the database. The page I have written can only hold 35 records at a time. I know that I can use "SELECT TOP 35 FROM Table" to get the top 35 records, but I now need to get the remaining 20 records and put them on a new page. There is no "SELECT BOTTOM" and I'm not sure if I can tell the SELECT statement to only get those last 20 rows. The number of rows could be as many as 100 split into chunks of 35.Your assistance is greatly appreciated!Ariston Collanderaristoncc@gmail.com" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Select specific number of records 