SQL to return records in m,n sequence

I want my SQL to return only records from 101 to 200.
See below options which would do the required..


Select *
from (Select rownum rownumber,employee.*
from employee)
Where rownumber between 101 and 200; -- Using rownum label in oracle

Select *
from (Select employee.*,
row_number() over (order by emp_id desc) Rownumber
from employee)
where Rownumber between 101 and 200; --Using the analytical function row_number

Select *
from (Select employee.*,
row_number() over (order by emp_id desc) Rownumber
from employee)
where Rownumber between :Fromnumber and :tonumber; -- lets user decide the recordset chunk...

Hope this is helpful!!!!!!