关于oralce分页的二种写法

关于oralce分页的2种写法
1. 

SELECT X.*  FROM (SELECT ROW_NUMBER() OVER(ORDER BY FieldName DESC) AS ROW_NO,               A.*          FROM table A) X WHERE X.ROW_NO <= 41   AND X.ROW_NO >= 21;