I Don't Have SQL to hand to test by think something like this would work;
Select Top 1 * From ( Select Top 2 * From Salaries Order By Salary Desc) Order By Salary Asc;
Which should in theory give you the 2nd highest salary, by first creating a set of highest 2 salaries and then flipping the order and returning the lowest.