SELECT *
FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY ID DESC) AS rownum,
FROM TABLE) AS T
WHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesize
pagenum是当前页,pagesize是每页显示的个数
可以嵌套
SELECT *
FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY ID DESC) AS rownum,
FROM (Select * From Table where something='some')AS W) AS T
WHERE rownum BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesize