[Oracle] 分页查询

iteye_9077

于 2014-12-17 16:59:47 发布

阅读量134

点赞数

分类专栏： Oracle 文章标签： oracle

本文链接：https://blog.youkuaiyun.com/iteye_9077/article/details/82611345

版权

Oracle 专栏收录该内容

19 篇文章

订阅专栏

    -- 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