CODE EXAMPLE FOR SQL

query to find third highest salary

-*FOR THIRD HIGHEST SALARY*

Select top 1 from (select top 3 salary from emp order by salary desc)
order by asc