[Oracle] 分页查询

    -- Oracle分页（效率好）
    SELECT * 
      FROM (SELECT A.*
                 , ROWNUM RN 
              FROM (SELECT * 
                      FROM EMP
                   ) A 
             WHERE ROWNUM <= 200 
           ) 
     WHERE RN >= 100;
     
    -- Oracle分页（效率不好）
    SELECT *
      FROM (SELECT A.*
                 , ROWNUM RN 
              FROM (SELECT * 
                      FROM EMP
                   ) A 
           )
     WHERE RN BETWEEN 100 AND 200