oracle how to get rows between x and y


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;

Leave a Reply