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