Select Top 1 (Salary) from emp where salary not in (select Top 3 (Salary)

write query for fourth maximum salary from employee table

Question Posted / pramod

Answer Posted / pramod

Select Top 1 (Salary) from emp where salary not in
(select Top 3 (Salary) from emp order by salary desc)
order by salary desc

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to insert data with null values?

762

What is difference between order by and group by?

753

How to find the version of sql server? : sql server database administration

809

What is executereader?

724

Explain indexed views and partitioned view with their syntax.

893

What you can do to delete a table without the delete trigger firing?

708

Can group functions be mixed with non-group selection fields in ms sql server?

700

what is blocking? : Sql server database administration

714

What is rtm version in sql server?

696

How to delete exactly duplicate records from a table?

803

Can we use max in where clause?

695

What is Sqlpaging in SqlServer 2005 ?

843

What is the use of set nocount on/off statement?

818

What is query optimizer in sql server?

731

Difference between connected and disconnected database in .net with sql server?

770