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

How to write a query with an inner join in ms sql server?

999

What is proper subset of candidate key?

948

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1453

How to scale out a federation by Sql statement?

116

What is the partitioning method?

975

Explain how you can deploy an SSRS report?

137

Equi join and non equi join is possible with sql server?

941

Do you know what is fill factor and pad index?

941

How to insert data into an existing table?

921

What is the tcp/ip port on which sql server runs?

1062

Does a specific recovery model need to be used for a replicated database? : sql server replication

914

What is the function of sql server agent windows service?

1030

What guidelines should be followed to help minimize deadlocks?

870

Explain what is raid and what are different types of raid levels?

954

What are scalar functions in sql?

1080