LeetCode-184：部门工资最高的员工

SELECT d.Name as Department, e.Name as Employee, e.Salary
FROM Employee e, Department d
WHERE e.DepartmentID = d.Id AND
(e.Salary, e.DepartmentID) IN 
(SELECT MAX(SALARY), DepartmentID FROM Employee group by DepartmentID);