Select the #n to #m records in MS SQL Server

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))