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 many memory layers are in the oracle shared pool?

1184

What happens if you lost a data file?

1036

How do I limit the number of rows returned by an oracle query after ordering?

1170

How to display employee records who gets more salary than the average salary in the department?

1067

Where are the settings stored for each instance in oracle?

1105

How to export data to a csv file?

1307

what are archived logs?

2203

How to get a list of all background sessions in the database?

993

How to enter a new row into a table interactively?

1014

What is ordinary table in oracle?

1159

What are the uses of Database Trigger ?

1721

State and explain about oracle instance?

1000

What is data file?

1110

What is a trigger and what are its types?

1231

What is tns name?

981