oracle语句20160922

SELECT
    *
FROM
    (
        SELECT
            ROWNUM NUM,
            T .*
        FROM
            HR.JOBS T
    ) TT
WHERE
    TT.NUM < 9
AND TT.NUM > 5

rownum伪列分页