185. 部门工资前三高的所有员工

1 # Write your MySQL query statement below
2 select d.name Department, e1.Name Employee, e1.Salary from Employee e1 left join Employee e2 
3     on e1.DepartmentId = e2.DepartmentId and e1.Salary < e2.Salary
4     join Department d on e1.DepartmentId = d.Id 
5     group by e1.Id having count(distinct e2.Salary) <=2 order by e1.Salary desc;