ROWNUM

——————–ilk 5 kayıt—————————————

select * from
(select rownum row_num,user_name.table_name.* from
user_name.table_name where rownum <= 5 )
where row_num > 0

——————belirli aralik arasi kayitlar————————

select * from
(select rownum row_num,user_name.table_name.* from
user_name.table_name where rownum <= 10 )
where row_num > 5

—————–tabloda sondan 6. kayıt örneği———————–

SELECT *
FROM (SELECT ROWNUM sirasi,table_name.*
FROM table_name)
WHERE sirasi = (SELECT (MAX (ROWNUM) – 5)
FROM table_name);