SQL Server select the #n to #m records
Since MS SQL Server don't provide rowid, This can be done with 'SELECT TOP':
SELECT TOP m-n+1 * FROM SOME_TABLE WHERE (SOME_KEY NOT IN( SELECT TOP n-1 SOME_KEY FROM SOME_TABLE))
|
||||
|
||||
Since MS SQL Server don't provide rowid, This can be done with 'SELECT TOP':
SELECT TOP m-n+1 * FROM SOME_TABLE WHERE (SOME_KEY NOT IN( SELECT TOP n-1 SOME_KEY FROM SOME_TABLE))
Discussion