Third Highest Salary ( T-SQL )

WITH CTE AS
(
SELECT  DepartmentID, SALARY,
DENSE_RANK() OVER (PARTITION BY DepartmentID ORDER BY SALARY DESC ) RANK_SALARY
FROM Employees
)

SELECT DISTINCT (DepartmentID), SALARY AS ThirdHighestSalary
FROM CTE
WHERE RANK_SALARY = 3;