Limit the number of rows return by Oracle query

select * from
( select a.*, ROWNUM rnum from
  ( <your_query_goes_here> ) a
  where ROWNUM <= :MAX_ROW_TO_FETCH )
where rnum  >= :MIN_ROW_TO_FETCH;