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

When to use Inner join & when to use subquery?

1166

What is co-related sub query?

1023

How to receive output values from stored procedures?

1146

Why would you call update statistics?

1020

When we should use and scope of @@identity?

999

what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration

912

Can we deploy SSRS reports on our personal website?

168

What is transaction server implicit?

1015

What happens when converting big values to numeric data types?

1139

What are the steps you must follow to hide sql server instances?

978

What is bit data type?

1042

What is the difference between rank and dense_rank?

1090

What is subquery? Explain the properties of a subquery?

990

What are the differences between left join and inner join in sql server?

1110

How to connect a database with sql express.?

1066