oracle sql分頁的寫法示例

SELECT * FROM 
    (SELECT a.*,rownum row_num FROM 
        (SELECT etpcode,etpename FROM tetp c ORDER BY c.etpcode DESC ) a
    ) b
WHERE b.row_num BETWEEN 1 AND 2