select Department.Name as Department, Employee.Name as Employee, Salary
from Employee, Department
where Department.Id = Employee.DepartmentId
and Employee.Salary =
(
select max(Salary)
from Employee e2
where e2.DepartmentId = Department.Id
)
Leetcode#184.部门工资最高的员工
最新推荐文章于 2022-10-19 11:16:45 发布