SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP N salary FROM #Employee ORDER BY salary DESC ) AS temp ORDER BY salary
SELECT salary FROM Employee ORDER BY salary DESC LIMIT N-1, 1