oracle分页查询:
SELECT
*
FROM
(
SELECT
ROWNUM AS rowno,
t.*
FROM
tablename t
WHERE
hire_date BETWEEN TO_DATE ('20060501', 'yyyymmdd')
AND TO_DATE ('20060731', 'yyyymmdd')
AND ROWNUM <= 20
) table_alias
WHERE
table_alias.rowno >= 10;