The method of extracting the article m to nth record with a SQL sentence

1-Remove the record from table M to nth: (not in version)
2
3 SELECT TOP n-m+1 *
4 from Table
5 WHERE (id not in (SELECT TOP m-1 ID from Table))
6
7
8--Remove the M-to-N record (exists version) from table tables
9
Ten SELECT TOP n-m+1 * from TABLE as a WHERE not Exists
One (SELECT * FROM (select Top m-1 * from TABLE ORDER by id) b Where b.id=a.id)
Order by ID
13
14
The--m is superscript, n is subscript, for example, take out the 8th to 12th record, m=8,n=12,table is the table name
16
+ 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

The method of extracting the article m to nth record with a SQL sentence