2nd Highest Salary

Select top 1  salary from (select distinct top 2 salary 
from employee order by salary desc)a
order by salary

2nd Least Salary

Select top 1  salary from (select distinct top 2 salary 
from employee order by salary asc)a
order by salary desc