- 部门工资最高的员工
思路使用JOIN 将两表数据关联,再根据条件查询得到按部门分类,且工资最高的部门。
Select d.Name Department ,e.Name Employee ,e.Salary Salary FROM
Employee e JOIN Department d ON e.DepartmentId = d.Id
WHERE (e.Salary,d.Id) IN(
SELECT Max(Salary),a.DepartmentId FROM Employee a GROUP BY a.DepartmentId)