Nth highest Salary.........................!  :P



select top 1 from
(select distnict top n from emp  --retrving the nth highest salary
order by sal desc) result
order by sal;



with result as
(select sal,dense_rank() over (order by salary desc) as denserank
from emp)

select salary 

from emp

where result.denserank=n;