leetcode 184.部门最高工资
184.部门最高工资
题解:
SELECT T1.name department, T.name employee, T.salary
FROM employee T, department T1
WHERE T.departmentid = T1.id
AND (salary, departmentId) IN
(SELECT MAX(salary), departmentId FROM employee GROUP BY departmentId)
分析:
GROUP BY
原创
2021-06-09 22:25:29 ·
93 阅读 ·
0 评论