SELECT * FROM EmpSalary SOURCE; WHERE Salary IN (SELECT TOP 2 Salary FROM EmpSalary WHERE Deptt=SOURCE.Deptt ORDER BY 1 DESC)