if you have a table emp and you have to find fourth maximum 
salary from emp table then you will have to write this 
query.....

select top 1 sal from (select top 4 * from emp order by sal 
desc) as sal order by sal