select salary from employee aa where 4=(select count(*)from employee bb w

write query for fourth maximum salary from employee table

Question Posted / elumalai.k

Answer Posted / elumalai.k

select salary from employee aa
where 4=(select count(*)from employee bb
where aa.salary<=bb.salary)

Is This Answer Correct ?

4 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What is the standby server?

937

What is default port number for sql server 2000?

1023

What are the components of sql server service broker?

989

Explain transaction isolation levels in sql server?

1088

What is reportserver and reportservertempdb ?

152

Why are sql functions used?

1096

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1032

How global temporary tables are represented and its scope?

947

ow to bring suspect mode datbase online from scratch

1789

What is a functions and types in sql server?

1059

Does group by sort data?

882

What is dimension table? : sql server analysis services, ssas

1001

What does ss stand for sexually?

1058

What are the different sql server versions?

962

Write an sql query to find first weekday of the month?

899