MySQL/185. Department Top Three Salaries 部门工资前三高的员工

题目

---

 

 

 

 

代码部分一（1423ms）

SELECT
    d.Name AS Department,e1.Name AS Employee,e1.Salary AS Salary
    FROM Employee e1,Department d
    WHERE d.id=e1.DepartmentId AND (
        SELECT COUNT(DISTINCT e2.Salary) FROM Employee e2 WHERE e2.DepartmentId=d.Id AND e2.Salary>e1.Salary
    )<3
    ORDER BY e1.Salary;