SELECT d.Name AS ‘Department‘, e1.Name AS ‘Employee‘, e1.Salary FROM Employee e1 JOIN Department d ON e1.DepartmentId = d.Id WHERE --子查询 逆向思维 3 > (SELECT COUNT(DISTINCT e2.Salary) FROM Employee e2 WHERE e2.Salary > e1.Salary AND e1.DepartmentId = e2.DepartmentId )
原文：https://www.cnblogs.com/xiaoshahai/p/12182763.html