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 - 2001-07-02 : 13:14:57
|
| Natraj writes "What should be the query if i want to select values from a table specifying the starting row or record number.For example: I have a table with 3 columns including a primary key column.Suppose this table has 1000 rows, the query should be placed in such a way that the searching should start from the 900th row.[Lets say by some way i get the rownumber--which i dont know how???]select * from tablename where (rownumber > 900)The implicit question is how do i retrieve the internal rownumber that SQL server maintains. I cannot use Identity property also, since the primary key is not necassrily an integer." |
|
|
|
|
|
Searching a table starting from a specific row / record number number