利用行号生成函数 row_number

select* from
(select ROW_NUMBER() OVER(ORDER BY T.id DESC) AS RowNumber, T.* from T ) 
as temp
where rownumber between 10 and 20