184. Department Highest Salary

问题描述

解决方案

select b.Name Department,a.Name Employee,a.Salary from
(
select  e1.Salary,e1.Name,e1.DepartmentId from Employee e1 
where e1.Salary=(select max(Salary) from Employee e2 where e1.DepartmentId=e2.DepartmentId)
) a,Department b

where a.DepartmentId=b.Id