[데이터 베이스]14.파티션별 순위 구하기

-- 4. 파티션
select deptno, ename, sal,
rank() over (partition by deptno order by sal desc) '순위'
from emp
order by deptno;

-- 5. 파티션 연습 (jumin에 있는 75, 76 등 나이별 키(height) 순위를 구하시오)
select name, age, height,
rank() over (partition by age order by height desc)
from
(
select name, substr(jumin,1,2) 'age', height 
from student
) st;