With help of subquery( inner query and outer query)

Query- select max(esal) from emp where esal <(select max (esal) from emp where esal <(select max(esal)

from emp))

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

as comp order by salary asc

Select top 1 salary

from

(Select top 3 salary

From table_name

Order by salary desc ) as comp

order by salary asc

By using" order by" query