LeetCode:Department Highest Salary

最新推荐文章于 2025-05-07 15:46:24 发布

原创最新推荐文章于 2025-05-07 15:46:24 发布 · 905 阅读

0 ·

CC 4.0 BY-SA版权

LeetCode 专栏收录该内容

47 篇文章

订阅专栏

本文介绍如何自定义每个部门的最高薪水表，并通过连接查询来获取详细信息。

自定义每个部门最高薪水表，然后三个表连接查询

select d.Name as Department, e.Name as Employee, e.Salary as Salary
from Employee e, Department d ,
(select DepartmentId ,MAX(Salary) as Salary from Employee group by DepartmentId  ) t
where e.DepartmentId=t.DepartmentId and e.Salary=t.Salary and d.Id=e.DepartmentId;