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 drop a stored procedure in oracle?

592

How to create an oracle database manually?

570

Is the After report trigger fired if the report execution fails ?

2405

How to connect asp pages to oracle servers?

577

What is an oracle table?

557

Is there a combination of "like" and "in" in sql?

583

Can the query output be sorted by multiple columns in oracle?

574

What is rowid and rownum in oracle?

545

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1661

Which is faster join or subquery in oracle?

537

What is Virtual Private Database in Oracle?

624

How to resolve name conflicts between variables and columns?

573

IS it possible to built the oracle database without setting the kernal parameters?

1763

What is backup in Oracle?

573

Explain oracle left join with an example?

588