数据库查询-部门工资最高的员工

参考答案：

select d.Name as Department,e.Name as Employee,e.Salary from Department d,Employee e where
 e.DepartmentId=d.Id and e.Salary=(Select max(Salary) from Employee where DepartmentId=d.Id)

答案解析：

1.查出department employee salary的全部值 

2.分别查出IT和Sales的最高工资