ORACLE中用ROWNUM分页并排序的SQL语句

直接分页
SELECT * FROM (SELECT A.*, ROWNUM ROW_NUM FROM XRH_EXCITATION AS A) AS B
WHERE B.ROW_NUM BETWEEN 1 AND 2

先倒序排序，再分页，最后取1-2条数据：
SELECT * FROM (SELECT B.*, ROWNUM ROW_NUM FROM
(SELECT * FROM XRH_EXCITATION AS A ORDER BY A.ID DESC) AS B) E
WHERE E.ROW_NUM BETWEEN 1 AND 2