Nth Highest salary

SELECT TOP 1 Salary

FROM (

    SELECT DISTINCT TOP 3 Salary

    FROM Employee

    ORDER BY Salary DESC

) AS Temp

ORDER BY Salary ASC;