oracle分页查询

 oracle 分页采用rownum来实现，内层小于等于，外出大于

SELECT *
FROM (SELECT A.*, rownum rn
         FROM (SELECT * FROM table_Name) A
           WHERE rownum <= pageIndex * pageSize)
WHERE rn > (pageIndex - 1)*pageSize