标题:mysql中,找出每个部门工资最高的员工。
一、题目
二、解题
使用了内连接,子查询
select a.name 'Department',e.name 'Employee', a.salary 'Salary'
from employee e
inner join (
select max(salary) 'Salary',d.`id` id,d.`name` name
from employee e
inner join department d
on e.departmentId=d.id
group by e.departmentId
) a
on e.`departmentId`=a.id and e.`salary`=a.Salary