oracle分页查询

1、分页查询1--上限条件必须放在子查询，而下限条件必须放在外层查询

SELECT * FROM
(
  SELECT A.*,ROWNUM RN
  FROM (SELECT * FROM AM_ACCT_NET)  A
  WHERE ROWNUM<=50
)
WHERE RN>=2;

2、分页查询2

SELECT * FROM
(
   SELECT A.*,ROWNUM RN
   FROM  (SELECT * FROM  AM_ACCT_NET)  A
)
WHERE RN BETWEEN 2 AND 50;

3、实例

SELECT * 
FROM (SELECT ROWNUM AS ROWNO,T.*
  FROM AM_ACCT_NET T
  WHERE T.POST_DATE BETWEEN ('20170307')
  AND ('20180809')
  AND ROWNUM<=40)
  WHERE ROWNO>=1;

结果