Question- Find 4th highest salary of a employee in employee table.

Ans- '' select top 1 salary, name from (select distinct top 4 salary, name from employee order by salary DESC) emp order by salary"