SQL Server selects a tuple of row m to nth row

Now there is a table Questioin, the main code is QID, which requires the selection of the tuple of row m to nth row

Method One: Lowest efficiency

Error: If n<m, the first n data will be selected, and if N>=m, n data starting from M+1 will be selected

Select Top *  from Question where  not inch {selecttop  m qid from Question}

Of course, it's the right thing to change.

Select Top (n-m) *  from  wherenot in(Selecttop from Question )

Method Two: Sorting first, said to be the most efficient

Select Top *  from (Selecttop*fromorderbyASC) A  orderbydesc

Method Three: Use the Row_number function to set the tuple number (recommended)

SELECT *  from (SELECTover (ORDER by as RowIndex,* from Question) bWHERE b.rowindex>= and B.rowindex<=N

SQL Server selects a tuple of row m to nth row