SQL Advanced Operations

Retrieve records from the Table from entry m to entry n: (Not In version) Select top n-m + 1 * FROM Table WHERE (id not in (select top M-1 id FROM Table )) Retrieve records m to n from the TABLE (Exists Version) Select top n-m + 1 * from table as a WHERE Not Exists (Select * From (Select Top m-1 * From TABLE order by id) B Where B. id = a. id) Order by id M is the superscript and n is the subscript. For example, 8th to 12 records are retrieved, m = 8, n = 12, and Table is the Table name. Select Top n-m + 1 * From Table Where Id> (Select Max (Id) From (Select Top M-1 Id From Table Order By Id Asc) Temp) Order By Id Asc