[LeetCode] Department Top Three Salaries

https://leetcode.com/problems/department-top-three-salaries/

LeetCode - The World's Leading Online Programming Learning Platform

 

각 부서별로 동률을 고려하여 부서별 top3 연봉에 해당하는 부서, 직원, 급여을 출력하는 문제이다.
DENSE_RANK를 알면 끝.

SELECT
    DEPARTMENT,
    EMPLOYEE,
    SALARY
FROM(
    SELECT
        DEPARTMENT.NAME AS DEPARTMENT,
        EMPLOYEE.NAME AS EMPLOYEE,
        EMPLOYEE.SALARY AS SALARY,
        DENSE_RANK() OVER (PARTITION BY DEPARTMENT.NAME ORDER BY SALARY DESC) AS D_RANK
    FROM EMPLOYEE JOIN DEPARTMENT ON EMPLOYEE.DEPARTMENTID = DEPARTMENT.ID
) AS SUB
WHERE D_RANK <= 3