Oracle分页操作的几种方法

第一种：　　　　

SELECT * FROM (SELECT A.*, ROWNUM RN FROM (SELECT TEST_USER_NAME,TEST_DATE from PBS_TEST_REPORT order by test_date desc) A WHERE ROWNUM <= 10 ) WHERE RN >0