判断当前页数是否大于1
如果是number则为1,否则number为0
select * from
(select *, ROW_NUMBER() OVER(Order by Id )
AS RowNumber from emplment)
as b
where RowNumber BETWEEN (当前页数-1)5 and 当前页数5-number
sqlserver分页查询
最新推荐文章于 2024-05-08 10:26:40 发布
判断当前页数是否大于1
如果是number则为1,否则number为0
select * from
(select *, ROW_NUMBER() OVER(Order by Id )
AS RowNumber from emplment)
as b
where RowNumber BETWEEN (当前页数-1)5 and 当前页数5-number