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

What privilege is needed for a user to insert rows to tables in another schema?

990

Give the constructs of a package, function or a procedure.

1015

What is java oracle used for?

1002

Where do you use decode and case statements?

979

How to invoke the original export import utilities?

1033

What are dml statements in oracle?

1072

How to Truncate Table in Oracle

1134

What is the use of oracle?

1018

Please explain compound trigger in oracle?

1034

How to create an oracle testing table?

1040

What is private procedure oracle?

994

What is open database communication (odbc) in oracle?

987

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2315

How to add a new column to an existing table with a default value?

1000

What are data pump export and import modes?

1046