[데이터베이스 통계쿼리] 11. 파티션 by

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