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

Who developed sql server?

877

How can we determine what objects a user-defined function depends upon?

952

What is the difference between char and varchar2 datatype in sql?

1009

Which is faster statement or preparedstatement?

894

Do you know what guidelines should be followed to help minimize deadlocks?

922

optimization techinques

2637

How to Check if table exists in sql server?

1075

What have included columns when we talk about sql server indexing?

991

What are the three different part of rdl file explain them?

253

How to delete duplicate rows in sql server?

1057

What does asynchronous call backs means?

1073

How many cores do I need for sql server 2016?

850

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1132

How to download and install microsoft sql server management studio express?

976

What is sub-query in sql server?

1141