SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY [id] ASC) AS RowNum, * FROM table) AS T WHERE RowNum BETWEEN X AND Y
SQL SERVER2005的row_number()实现分页
最新推荐文章于 2022-11-22 18:17:27 发布
SELECT * FROM (SELECT ROW_NUMBER() OVER (ORDER BY [id] ASC) AS RowNum, * FROM table) AS T WHERE RowNum BETWEEN X AND Y