Oracle数据库查询高效率分页

Oracle数据库查询高效分页
1.select *
2.  from (select *
3.          from (select t.*,
4.                       row_number() OVER(ORDER BY null) AS "row_number"
5.                  from yz_bingrenyz t) p
6.         where p."row_number" > 5000
7.        ) q
8. where rownum <= 30