DECLARE @pagenum AS INT, @pagesize AS INT
SET @pagenum = 2
SET @pagesize = 2
select * from (
select row_.*, ROW_NUMBER() OVER (ORDER BY 主键ID) AS rownum_ from (
select * from 表名
) row_
) A
where rownum_ BETWEEN (@pagenum-1)*@pagesize+1 AND @pagenum*@pagesize
SqlServer相对通用数据库分页
最新推荐文章于 2024-09-25 09:21:39 发布