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);
原创
2020-05-09 00:40:37 ·
107 阅读 ·
0 评论