有两张表:
employee 表
department 表
要求找出每个部门工资最高的人的 姓名、所在部门、工资。
查询结果如图,
sql语句为:
select department.name Department,employee.name Employee,max(salary) Salary from employee
inner JOIN department on employee.department = department.id group by department