Department Top Three Salaries
SELECT 
      D.Name AS Department, 
      E.Name AS Employee, 
      E.Salary AS Salary
FROM Employee E 
INNER JOIN Department D 
ON E.DepartmentId = D.Id 
WHERE 3>(SELECT COUNT(DISTINCT Salary)
           FROM Employee E2
           WHERE E2.Salary > E.Salary
           AND E.DepartmentID = E2.DepartmentID); 
Comments (0)