关于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;

据说1到了1W条数据后每页都慢,据说2到了1W条数据后最后一页慢