分页

DEMO1:

SELECT *
  FROM (SELECT TEMP.*, ROWNUM RNUM
          FROM (SELECT t.*
                  FROM temp_20160829_2 t
                 WHERE 1 = 1
                 ORDER BY t.area_id 
                ) TEMP
         WHERE ROWNUM <= 300
        )
 WHERE RNUM >= 250

DEMO2:

SELECT *
  FROM (SELECT TEMP.*, ROWNUM RNUM
          FROM (SELECT *
                  FROM temp_20160829_2 t
                 WHERE 1 = 1
                 ORDER BY t.area_id
                ) TEMP
        )
 WHERE RNUM >= 30
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/xiluhua/p/10297794.html