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-09-24 23:52 腾讯_研发工程师
关注
全部评论
相关推荐
投递科大讯飞等公司10个岗位 > 点赞 评论 收藏
转发
腾讯HR面427人在聊 点赞 评论 收藏
转发
点赞 评论 收藏
转发