高效ORACLE分页语句

无order by排序：

SELECT * FROM (

SELECT ROWNUM AS rn, t.*

FROM tableName t

WHERE ROWNUM <= 20

) tt WHERE tt.rn>= 10;

有order by排序：

SELECT * FROM (

SELECT t.*, ROWNUM as rn FROM (

SELECT * FROM tableName

ORDER BY a ASC;

) t where ROWNUM <= 20

) WHERE rn > 0;