SELECT 'Second Highest Salary Is ', MAX(Salary) FROM Employee WHere Salary < ( Select MAX(Salary) FROM Employee )

SELECT 'Second Least Salary Is ',MIN(Salary) FROM Employee  WHere Salary > ( Select MIN(Salary) FROM Employee )

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

select p.emp_id,p.name,p.salary from
(select emp_id,name,salary,dense_rank()over( order by 
salary desc)maxrank,
dense_rank()over( order by salary asc)minrank from test)p
where maxrank=2 or minrank=2

for 2nd highest salary

select max(salary) from employee where salary<(select max
(salary) from employee )


for 2nd least salary

select min(salary) from employee where salary>(select min
(salary) from employee )

i hope that will help you

select distinct top 1 salary from payroll..emp where salary 
in(select distinct top 3 salary from payroll..emp order by 
salary desc)

select distinct top 1 salary from payroll..emp where salary 
in(select distinct top N salary from payroll..emp order by 
salary desc)

if u want top 2 put 2 at the pacece of N
if u want top 5 put 5 at the pacece of N
if u want ..............................