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 are the advantages of paper records?

1012

Can we use where clause in union?

1124

What are the types of lock supported by ?

1093

How can you stop stored procedures from recompiling?

948

How to connect to SQL Azure Database by using sqlcmd?

140

What does normalization do to data?

1141

What is CTE in SQL

996

What is normalization and denormalization in sql server?

1065

Explain four layers of abstraction microsoft architectured?

147

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1074

What is the use of nvl work?

1045

What are sql server functions?

1028

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

1147

What is the purpose of the model database?

1067

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

1014