oracle 에서 limit 함수 사용

select NE_NO, NE_NAMe
from cf_ne
order by ne_no asc
limit a, b

a = 1 ,b = 10 일때

--------------------------------------------------------------------변환

select * from (select * from (select NE_NO, NE_NAMe
from cf_ne
order by ne_no asc)where rownum < a+b order by ne_no desc)
where rownum < b+1 Order by ne_no