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 - 2004-05-03 : 13:05:07
|
| Sreedhar writes "Hi,I want "35th" row or say any "nth" row of a table to be returned through a query .As there is no rowid like thing in SQL Server, i tried using set operations like say i want to retrieve 5 th row, I tried difference of top 5 and top 4 through NOT EXISTS , it should have worked but gave me 0 rows. Then i searched and found out Except function which will do the same but SQL Share violation error is coming . Is there any other way i can achieve the result" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-03 : 13:23:37
|
| http://www.sqlteam.com/item.asp?ItemID=16134Tara |
 |
|
|
|
|
|
Queries Set Operations