Identify the correct query or queries for displaying second highest salary ?
select top 2 salary into toppaidemps from employees order by salary desc ;
select top 1 salary from toppaidemps order by salary asc ;
select top 2 max(salary) from employees order by max(salary)
select top 1 salary from employees
where salary > Any ( select top 1 salary from employees order by salary desc ) order by salary desc
First and third queries will give the second highest salary
Back To Top