[Database] 19. 파티션

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, height, substr(jumin,1,2) 'age'
from student) e
order by age;