摘要： with temptbl as ( SELECT ROW_NUMBER() OVER (ORDER BY id desc)AS Row from 表名)SELECT * FROM temptbl where Row between 开始值 and 结束值第二种：SELECT *FROM (SELECT ROW_NUMBER() OVER(ORDER BY id DESC, id) AS rownu... 阅读全文