How to display the records between two range of rownum in Oracle?

Answer 1

Use BETWEEN operator that displays the records between 2 ranges from single table.

SELECT * from
(
select m.*, rownum r
from maps006 m
)
where r > 49 and r < 101

2. select * from emp where sal between 1000 and 3000