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

What are the differences between having and where clause.

1016

What is self contained multi valued query?

1074

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

1029

What is the impact on other user sessions when creating indexes?

963

Explain user defined views?

1008

How to change server name in sql server?

1250

How to skip remaining statements in a loop block using continue statements?

1041

What are commonly used mssql functions in php?

1141

What is postgresql server?

1057

How do I find the port number for sql server?

1017

How do you create a data source?

959

What are various ways to enhance the ssrs report?

1032

What is report server project?

155

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

982

Mention the different types of replication in sql server.

1068