how to get middle rows in a table
Hi,
if I have a table of 1000 records, I need to fetch 100 at a time. or say 200 to 300 records. Can anyone please suggest a best way of doing it? I am following the below approach.
select * from (select *,rownum num from table1 )where num >200 and num <300
is there any other better way (in terms of performance)??
Thanks