Oracle 实现分页查询功能

方式一：

    

SELECT * FROM (

SELECT A.*, rownum r FROM (

SELECT * FROM a_matrix_navigation_map ) A

 WHERE rownum <= 10) B

WHERE r > 0

 

方式二：

 

SELECT * FROM table WHERE ROWNUM<21;

minus

SELECT * FROM table WHERE ROWNUM<10;

 

方式三：

select * from a_matrix_navigation_map

where rowid not in(select rowid from a_matrix_navigation_map where rownum<=0) and rownum<=10