SQL レコード取得 位置指定

[oracle]

SELECT T1.aaa, T2.bbb FROM xxxTable T1 OFFSET 50 ROWS FETCH NEXT 50 ROWS ONLY;

SELECT rn, aaa, bbb FROM

(SELECT ROWNUM AS rn, T10.aaa, T10.bbb FROM

(SELECT T1.aaa, T1.bbb FROM xxxTable T1) T10

)

WHERE rn > 50 AND rn <= 100;

どちらも、50レコード目から50レコード取得