[DATABASE/ORACLE] RANK 함수와 DENSE_RANK 함수 사용하기

■ RANK 함수와 DENSE_RANK 함수를 사용하는 방법을 보여준다.

 

▶ 예제 코드 (SQL)

WITH TEMP AS
(
    SELECT '1' CD, 'AAA' NAME FROM DUAL
    UNION ALL
    SELECT '1' CD, 'ASD' NAME FROM DUAL
    UNION ALL
    SELECT '2' CD, 'SDF' NAME FROM DUAL
    UNION ALL
    SELECT '3' CD, 'ASA' NAME FROM DUAL
    UNION ALL
    SELECT '3' CD, 'RRR' NAME FROM DUAL
    UNION ALL
    SELECT '4' CD, 'DDD' NAME FROM DUAL
)
SELECT
    A.*
   ,RANK() OVER(ORDER BY CD) RN
   ,DENSE_RANK() OVER(ORDER BY CD) DRN
FROM TEMP A;