在sqlserver中,可以使用 between and 函数实现分页查询。例句:
select * from
(select ROW_NUMBER() over (order by ID desc) as Rownumber, * from tb_Orders) A
where rownumber between 11 and 20
在sqlserver中,可以使用 between and 函数实现分页查询。例句:
select * from
(select ROW_NUMBER() over (order by ID desc) as Rownumber, * from tb_Orders) A
where rownumber between 11 and 20