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
What is a table index in oracle?
Is truncate autocommit in oracle?
What is raw datatype?
Does oracle database need java?
Can group functions be mixed with non-group selection fields?
Does oracle charge for java?
What is the simplest tool to run commands on oracle servers?
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.
How to connect to oracle using service name instead of sid?
What are group functions in oracle?
How to write numeric literals in oracle?
How to assign a tablespace to a users in oracle?
How many types of table in Oracle?
 How to use an oracle sequence generator in a mapping?
Explain oracle’s server parameter file.