select min(salary) from ( select top 4 * from employees order by

write query for fourth maximum salary from employee table

Question Posted / ilgian

Answer Posted / ilgian

select min(salary)
from (
select top 4 *
from employees
order by salary desc
) as a

Is This Answer Correct ?

24 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Explain triggers?

966

What is a unique index?

901

How do I setup a sql server database?

1030

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

912

What is the boxing and unboxing concept in .net?

887

What is Dependency Injection and provide example?

1071

What is inline table-value user-defined function?

1056

How to create new tables with "create table" statements in ms sql server?

1026

What are translations and its use? : sql server analysis services, ssas

1014

What is checkpoint process in the sql server?

984

What do you mean by acid?

949

how to control the amount of free space in your index pages? : Sql server database administration

1005

Define ACID properties in a Database?

1019

What is intellisense?

1016

How to create an identity column?

1160