Oracle Pagenation 換頁

Pagenation 換頁 :
SELECT * from (select n.*,rownum num from XX.TABLE1 n WHERE rownum <=100) where num >= 50;
//第50~100筆