select * from [tablename]  order by colname desc offset 要跳过的行数(一般是pagenum x pagesize) rows fetch next 要读取的行数(一般是pagesize) rows only

例如:

select * from [user] order by id desc offset 40 rows fetch next 20 rows only

读取user表id倒序后41行起20行数据