无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;