[데이터베이스] 80. 통계쿼리 함수들 (3) 파티션별 순위구하기

-- 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;