sqlserver 分页sql
select * from (
select p.* ,row_number() over(order by createdate desc) num_id
from table p
where 查询条件
)t
where t.num_id between (pageNum - 1) * num + 1 and (pageNum - 1) * num + num
pageNum :第几页
num: 每页多少条
select * from (
select p.* ,row_number() over(order by createdate desc) num_id
from table p
where 查询条件
)t
where t.num_id between (pageNum - 1) * num + 1 and (pageNum - 1) * num + num
pageNum :第几页
num: 每页多少条