SQL分页语句
<br />select top 每页显示的记录数 * from topic where id not in (select top (当前的页数-1)×每页显示的记录数 id from topic order by id desc) order by id desc <br /> with temptbl as ( SELECT ROW_NUMBER() OVER (ORDER BY id desc)AS Row, ... ) SELECT * FROM temptbl
复制链接