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
How to create an oracle database?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What privilege is needed for a user to insert rows to tables in another schema?
What is the difference between count (*), count (expression), count (distinct expression)?
How many types of database triggers exist?
List out the difference between commit, rollback, and savepoint?
Describe varray?
What do you mean by cdb and pdb in oracle 12c?
How to create a table interactively?
How to create an initialization parameter file?
In oracle there is column command, how will you explain that?
What are the differences between blob and clob in oracle?
What is the meaning of recursive hints in oracle?
What are the ansi data types supported in oracle?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?