【LeetCode刷题】数据库之中等题：184. 部门工资最高的员工

题目：

思路：

• 先分组找出每个部门对应的最高工资

select DepartmentId,max(Salary)
from Employee
group by DepartmentId

• 再用IN从里头找到对应的员工

MySQL：

select d.Name as Department,
e.name as Employee,
e.Salary
from Employee as e join Department d on e.DepartmentId=d.id
where(e.DepartmentId,e.Salary) in 
(
    select DepartmentId,max(Salary)
    from Employee
    group by DepartmentId
)