分页查询

不带排序的分页查询
SELECT *
  FROM (SELECT ROWNUM RN, T.* FROM T_RY T WHERE ROWNUM <= 10)
 WHERE RN >= 1;
 
带排序的分页查询
 SELECT *
   FROM (SELECT ROWNUM RN, A.*
           FROM (SELECT ROWNUM r ,T.* FROM T_RY T ORDER BY RYBS ASC) A
          WHERE  r<= 10)
  WHERE RN >= 1;

注意：ROWNUM总是从1开始，查询的时候内查询需要必须是小于号，外查询是大于号。如果分页信息都在外查询，则必须先小于在大于。下面例子所示

不带排序的分页查询
SELECT A.*
  FROM (SELECT T.* FROM XT_RY T) A
 WHERE ROWNUM <= 10
   AND ROWNUM >= 2;

带排序的分页查询
SELECT A.*
   FROM (SELECT T.* FROM XT_RY T ORDER BY RYBS ASC) A
  WHERE ROWNUM <= 10
    AND ROWNUM >= 2;

如果分页查询是先大于后小于查到的数据为空，如下面例子所示

不带排序的分页查询
SELECT A.*
  FROM (SELECT T.* FROM T_RY T) A
 WHERE ROWNUM >= 2
   AND ROWNUM <= 10;

带排序的分页查询
SELECT A.*
   FROM (SELECT T.* FROM T_RY T ORDER BY RYBS ASC) A
  WHERE ROWNUM >= 2
    AND ROWNUM <= 10;