[LeetCode] 184. Department Highest Salary

 

 

[문제]

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

 

 

[MySQL]

WITH highest_salary AS (
    SELECT *
         , MAX(salary) OVER (PARTITION BY departmentId ORDER BY salary DESC) AS highest_salary
    FROM Employee
)

SELECT d.name AS Department
     , hs.name AS Employee
     , hs.salary AS Salary
FROM highest_salary AS hs
    LEFT JOIN Department AS d ON hs.departmentId = D.id
WHERE hs.salary = hs.highest_salary