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

How to Truncate Table in Oracle

1216

How to find the duplicate rows count from employees table in oracle?

1148

How to establish administrator authentication to the server?

1099

How to write an inner join with the where clause in oracle?

1091

What are the advantages of oracle?

1072

Explain mutating triggers.

1088

What is a parameter file in oracle?

1191

Explain the dml?

1051

How to open and close an explicit cursor in oracle?

1099

What is Library Cache in Oracle?

1191

What privilege is needed for a user to connect to oracle server?

1035

What is connection pool in oracle?

1038

What is a database table in oracle?

1071

How many anonymous blocks can be defined?

1253

Explain the use of record length option in exp command.

1120