select * from emp a where 3>=(select count(distinct(b.sal)) from emp b

a query to select maxmun 3 salaries of employee table

Question Posted / raju

Answer Posted / raju

select * from emp a where 3>=(select count(distinct(b.sal))
from emp b where b.sal>=a.sal )

Is This Answer Correct ?

4 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is a package in oracle?

566

What operating systems are supported by oracle database 10g xe?

583

How to view all columns in an existing table?

551

What is enter substitution variable in oracle?

573

Explain the use of indexes option in exp command.

595

What is a user role in oracle?

613

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1661

What is the difference between hot backup and cold backup in oracle?

523

How to bring a tablespace offline?

543

How can we delete duplicate rows in a table?

567

What are the attributes of the cursor?

561

How would you go about verifying the network name that the local_listener is currently using?

1609

What is the difference between a user and a schema in oracle?

564

How to connect to a local oracle 10g xe server?

536

What are the oracle built-in data types?

564