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

write query for fourth maximum salary from employee table

Question Posted / ilgian

14 Answers
24521 Views
Mind Tree, SP Software, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How will you decide the active and passive nodes?

1143

What are the different types of indexes?

1124

what are triggers? : Sql server database administration

915

How can a database be repaired?

999

what is database replicaion? : Sql server database administration

1204

How to verify a login name with sqlcmd tool?

1231

Describe in brief system database.

1020

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2034

What is coalesce and check constraint in sql server?

1130

how to create a scrollable cursor with the scroll option? : Sql server database administration

1100

How to create a simple table to test triggers in ms sql server?

985

If we delete pack Spec what will be the status of pack Body ?

1483

What is database isolation in sql server? : sql server database administration

1119

Show Practically Sql Server Views are updatable?

1131

What the different components in replication and what is their use?

962