[SQL][Leetcode] 184. Department Highest Salary

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

Department Highest Salary - LeetCode

Problem                                                                                                                      

Analysis                                                                                                                     

1. Employee의 DepartmentId 와 Department의 Id가 같은 곳을 JOIN한다.

2. 그중에 MAX함수를 사용하여 Salary가 높은 곳을 찾는다.

 

Solution                                                                                                                    

SELECT D.NAME AS Department,E.Name AS Employee, E.Salary   
FROM Employee AS E
JOIN Department AS D ON E.DepartmentId = D.Id 
    AND E.Salary = (
        SELECT MAX(Salary) 
        FROM Employee AS T
        WHERE T.DepartmentId = E.DepartmentId
    );