select * from
( select a.*, ROWNUM rnum from
( your_query_goes_here, with order by ) a
where ROWNUM <= :MAX_ROW_TO_FETCH ) where rnum >= :MIN_ROW_TO_FETCH;
If you're inventing and pioneering, you have to be willing to be misunderstood for long periods of time
select * from
( select a.*, ROWNUM rnum from
( your_query_goes_here, with order by ) a
where ROWNUM <= :MAX_ROW_TO_FETCH ) where rnum >= :MIN_ROW_TO_FETCH;