select * from emp where sal in (select max(sal) from emp where level<=

a query to select maxmun 3 salaries of employee table

Question Posted / kannan

Answer Posted / kannan

select * from emp
where sal in (select max(sal) from emp
where level<=3
connect by prior sal>sal
group by level)

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to insert a record into a table?

1079

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2636

What is Library Cache in Oracle?

1150

what is the dual table in oracle?

1005

please explain.. DB architecture ...

2032

What are the predefined tablespaces in a database?

1098

Give the advantages and disadvantages of clusters.

1053

Give the various exception types.

999

what is port in oracle? how is it related to database application.

1955

How to revoke create session privilege from a user in oracle?

1027

Explain oracle 12c new features for developers?

1065

List the types of joins used in writing subqueries?

999

What is an oracle user account?

1002

What is partitioned table in Oracle?

1201

How to use subqueries with the exists operator in oracle?

1035