Oracle数据库查询高效分页

1.select*

2.from(select*

3.from(selectt.*,

4.row_number()OVER(ORDERBYnull)AS"row_number"

5.fromyz_bingrenyzt)p

6.wherep."row_number">5000

7.)q

8.whererownum<=30