oracle数据库下的分页查询
常规的分页思路：select *
from (select a.*, rownum as rnum
from (select * from burgess) a
where rownum = 5000
有较高效率的分页思路
select *
from (select *
from (select b.*, row_number() OVER(ORDER BY null) AS "row_number"
from burgess b) p
where p."row_number" > 5000) q
where rownum
页:
[1]