Eason [資料科學//Python學習/資料庫] & [拍片&剪片]

oracle 分頁三步驟

1. rownum分頁

    (select * from emp);

2.調動rownum  (以10為例)

   select rownum rn,a1.* from (select * from emp) a1 where rownum<=10;

   6~10筆

   select * from (select rownum rn,a1.* from (select * from emp) a1 where rownum<=10) where rn>=6;

3.查詢變化 

a.指定查詢列(只要變動最裡面的表a1欄位即可)

b.排序(只要變動最裡面的表a1 + order by )

EX: 顯示4~9筆 按salary 排序( 4 跟 9 是變量傳入)

      select * from (select rownum rn,a1.* from (select * from emp order by salary) a1 where rownum<=9) where  rn>=4;    

oracle 分頁3種方法