select salary from employee e where 4=(select count(*) from emp f where e

write a query for the fifth highest salary?

Question Posted / suparna

Answer Posted / suparna

select salary from employee e where 4=(select count(*) from
emp f where e.sal<f.sal)

Is This Answer Correct ?

8 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What is a driver in database?

1070

List various types of log-based recovery in DBMS.

936

What is a database string?

896

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

2499

Explain entity type?

945

What is the best database software for small businesses?

865

A lowest level of security by most RDBMS is

1093

What is a sequence? Explain it with one example?

1099

If the master device is full, how do I make the master database bigger?

910

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

2040

Is storing images in a database a good idea?

944

What is a database call?

970

What is the difference between database and server?

941

What is difference between server and database?

1020

Difference between sql and mysql?

2039