02.Oracle/DataBase
oracle 페이지당 10개씩 게시물 확인
1010
2009. 4. 4. 13:24
반응형
select *
from(
select rownum rnum, e.*
from (select * from emp doder by ename) e
order by e.ename;
) ee
where ee.rnum between 1 and 10;
from(
select rownum rnum, e.*
from (select * from emp doder by ename) e
order by e.ename;
) ee
where ee.rnum between 1 and 10;