SQL分页查询

 

select *
from
(
select *,
row_number() over(order by id desc) as rownum
from 表
)a
where rownum between 3 and 10 -- rownum between 11 and 20