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 would you store your query in an SSRS report or a Database server?

162

How to create percentile function?

154

How do I schedule a sql server profiler trace?

981

What is updatable resultset?

1008

What is a coalesce function?

1195

How can delete duplicate records in cte in sql server?

965

What is the difference between a view and a stored procedure?

1038

Explain a checkpoint?

1040

Give an example of SQL injection attack ?

1007

How to delete an existing row with delete statements in ms sql server?

1093

What is the need for group functions in sql?

1084

What are the events recorded in a transaction log?

1000

How to create an multi-statement table-valued function?

999

What is bcnf normalization form?

1116

What is always encrypted?

998