관리 메뉴

moozi

row_number() from절 뷰 본문

TIS_2018/응용sw2018_1기

row_number() from절 뷰

moozi 2018. 3. 7. 17:07

-- 1page
select *
from(
          select row_number() over(order by sal desc) as num, empno,ename
          from emp
          )
where num>=1 and num<=10;

-- 2page
select *
from(
          select row_number() over(order by sal desc) as num, empno,ename
          from emp
          )
where num>=11 and num<=20;

'TIS_2018 > 응용sw2018_1기' 카테고리의 다른 글

오라클연습문제05  (0) 2018.03.13
오라클연습문제04  (0) 2018.03.09
오라클연습문제03  (0) 2018.03.07
정규식 참고  (0) 2018.03.07
오라클연습문제02  (0) 2018.03.06
Comments