LeetCode | MySQL | 184. Department Highest Salary

184. Department Highest Salary

leetcode.com/problems/department-highest-salary/

Department Highest Salary - LeetCode

# Write your MySQL query statement below
SELECT d.name AS department
    , e.name AS employee
    , e.salary
FROM employee AS e
    INNER JOIN (
        -- 부서에서 가장 많이 벌 때에 그 임금과 부서id
        SELECT departmentid, MAX(salary) AS max_salary
        FROM employee
        GROUP BY departmentid
        ) AS dh ON e.departmentid = dh.departmentid
                AND e.salary = dh.max_salary
    INNER JOIN department AS d ON d.id = e.departmentid