LeetCode_184. 部门工资最高的员工

184. 部门工资最高的员工

• 1 . 联表查询
• 2 . 判断工资和部门是否相同
• 3 . 根据部门id分组查询每个部门的最大工资

select d.name as 'Department',e.name as 'Employee',e.salary as 'Salary' 
from Department d,Employee e
where e.DepartmentId = d.id 
and (e.Salary,e.DepartmentId) in
    (   
        SELECT
         MAX(Salary),DepartmentId
        FROM
            Employee e2
        GROUP BY DepartmentId
	)