Data Base -SQL Server

To find out 5 th Maximum Salary

select top 1 max(sal) from salary where
sal not in (select top 4 max(sal) from salary group by sal order by sal desc )


To find out 5 th value from Top
select top 1 * from salary where sal not in (select top 4 sal from salary )