select top 1 salary
from (select distinct top 6 salary from employee order by salary desc) a
order by salary
Type: Posts; User: jrameshvjr; Keyword(s):
select top 1 salary
from (select distinct top 6 salary from employee order by salary desc) a
order by salary