SQL Server implementation queries the data for article m to nth

1 --Take the record of article M to nth from table tables: (not in version)2 Select TOPN-M+1 * 3  from Table 4 Where(ID not inch(Select TOPM-1Id from Table ))  5 6 7 --Remove the M-to-N records from table tables (exists version)8 Select TOPN-M+1 *  from TABLE  asAWhere  not Exists9(Select *  from(Select TopM-1 *  from TABLE Order  byID) bWhereb.ID=a.id)Ten Order  byID One  A  - --m is superscript, n is subscript, for example, take out 8th to 12th record, m=8,n=12,table is the table name - Select TopN-M+1 *  from Table  the WhereId>(Select Max(Id) from  -(Select TopM-1Id from Table Order  byIdASC)Temp)  - Order  byIdASC

SQL Server implementation queries the data for article m to nth