How to retrieve 5th highest sal from emp table?

Answer Posted / amit bhagat

select min(a.sal) from (select distinct(d.sal) from emp
order by d.sal desc) a where rownum<=5

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a table index in oracle?

648


Is truncate autocommit in oracle?

651


What is raw datatype?

601


Does oracle database need java?

535


Can group functions be mixed with non-group selection fields?

542






Does oracle charge for java?

597


What is the simplest tool to run commands on oracle servers?

524


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1512


How to connect to oracle using service name instead of sid?

561


What are group functions in oracle?

592


How to write numeric literals in oracle?

627


How to assign a tablespace to a users in oracle?

602


How many types of table in Oracle?

625


 How to use an oracle sequence generator in a mapping?

575


Explain oracle’s server parameter file.

582