[LeetCode] 185. Department Top Three Salaries

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH salary_rank AS (
    SELECT *
        , DENSE_RANK() OVER (PARTITION BY departmentId ORDER BY salary DESC) AS dense_rk
    FROM Employee)

SELECT d.name AS Department
     , sr.name AS Employee
     , sr.salary AS Salary
FROM salary_rank AS sr
    LEFT JOIN Department AS d ON sr.departmentId = d.id
WHERE sr.dense_rk <= 3