select * from emp e where &n=(select count(distinct sal) from emp ee

a query to select maxmun 3 salaries of employee table

Question Posted / munna

Answer Posted / munna

select * from emp e where &n=(select count(distinct sal)
from emp ee where e.sal<=ee.sal);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the system predefined user roles?

579

what is IDE,DMV in sql server?

2232

Why is oracle database so popular?

557

What is truncate oracle?

523

How to connect asp pages to oracle servers?

565

How to load data from external tables to regular tables?

528

Is insert autocommit in oracle?

595

Can a formula column be obtained through a select statement ?

1840

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

2167

How to check the oracle tns settings?

564

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

571

How to unlock the sample user account in oracle?

550

How to best split csv strings in oracle 9i?

576

What are the various constraints used in oracle?

546

What are dml statements in oracle?

608