5. Display full details for the creditor/s who has received
the single largest payment. Do not use a table join or set
operator anywhere in your query.
Answer Posted / ajit
select *
from ( select sal from emp order by sal desc)
where rownum <= 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
 How to use an oracle sequence generator in a mapping?
What operating systems are supported by oracle database 10g xe?
What are the differences between blob and clob in oracle?
What is raw datatype in oracle?
Explain what are the uses of rollback segment?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is the usage of synonyms?
Why do we need oracle client?
what are steps for interface? where is exchange rate defined in which table?
Is there a function to split a string in plsql?
How to define a procedure inside another procedure?
What is system global area (sga) in oracle?
How do I start tns listener?
What are group functions in oracle?
How to convert times to characters in oracle?