In the followin query:
'N' represents
Nth Highest Salary eg: 1st Highest Salary, 2nd Highest Salary etc.
Query:
Select top(1) *
From Table_Name
Where Pk_ID_Column in
(
Select top(N) Pk_ID_Column
From Table_Name
Order by salary_column desc
)
Order by salary_column