with temptbl as ( -----临时表名 SELECT ROW_NUMBER() OVER (ORDER BY id desc)AS Row, * from 表名 ... ) SELECT * FROM temptbl where Row between @startIndex and @endIndex
select top 每页显示的记录数 * from topic where id not in (select top （当前的页数-1）×每页显示的记录数 id from topic order by id desc) order by id desc
