Oracle 분석함수에 ROW_NUMBER 사용방법에 대해서 알아보겠습니다 ROW_NUMBER는 정렬된 결과에 대해 순위를 부여하는 기능이다. 1. 예시쿼리 select deptno, weigth, name, RANK() OVER (PARTITION BY deptno ORDER BY weigth) as weigth_rank DENSE_RANK() OVER (PARTITION BY deptno ORDER BY weigth) as weigth_dense, ROW_NUMBER() OVER (PARTITION BY deptno ORDER BY weigth) as weigth_row from student ORDER BY deptno, weigth, name; 위 결과와 같이 RANK()와 DENSE_RANK()..
