select *

from (

select rownum num , empno, ename

from emp

)

where num between 2 and 5

------------------

we can also use row_number function