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 are temporal data types in oracle?

586

How to create a new table in oracle?

583

How to fetch the row which has the max value for a column?

530

What is Reduced List of Values?

1693

What is set verify off in oracle?

566

Explain table?

638

Can multiple columns be used in group by in oracle?

533

What are dml statements in oracle?

608

How to get last row id?

547

How to rename an index?

575

Differentiate between post-database commit and post-form commit?

535

List the parts of a database trigger.

563

List out the difference between commit, rollback, and savepoint?

609

What is an Oracle Instance?

677

What are the differences between date and timestamp in oracle?

545