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 export your connection information to a file?

1072

Is it possible to split the print reviewer into more than one region ?

2221

How to run create database statement again?

1073

How can we find out the duplicate values in an oracle table?

992

State and explain the different types of data models?

893

How to invoke the data pump import utility?

1079

What is the difference between substr & instr functions?

1118

What is ADDM Advisor in Oracle?

1111

How to find out what oracle odbc drivers are installed?

976

What is a procedure in oracle?

1068

What is pragma autonomous transaction in oracle?

989

How to start instance with a minimal initialization parameter file?

989

What are the advantages of oracle?

960

How do I know if oracle is installed on windows?

875

How to execute the package in oracle?

1035