[Leetcode] 184. Department Highest Salary

문제 출처

• https://leetcode.com/problems/department-highest-salary/

Department Highest Salary - LeetCode

 

나의 풀이(MySQL)

select dep.name as Department, emp.name as Employee, emp.salary as Salary
from
	-- part별 최대 급여를 받는 사람을 조회
    (select e.name, e.salary, e.departmentId
    from 
    	-- part별 최대 급여 게산
        (select departmentId, max(salary) as max_salary
        from Employee as e
        group by departmentId) as ds
    join Employee as e on ds.departmentId = e.departmentId
    where e.salary = ds.max_salary) as emp
join Department as dep on emp.departmentId = dep.id