leetcode 184. 部门工资最高的员工

# Write your MySQL query statement below
select t2.name as Department,
t1.name as Employee,
t1.Salary from 
Employee t1
inner join
Department t2
on t1.DepartmentId=t2.Id
where (t1.Salary,t1.DepartmentId) in 
(select max(Salary),DepartmentId from Employee group by DepartmentId)