oracle how to get rows between x and y August 2, 2010 at 3:35 pm
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;
Margus Roo
Einstein once said you don’t really understand anything until you can explain it to your GrandmotherThe Master
Leave a Reply
You must be logged in to post a comment.