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 / devraj
Select * From cust_data Where trxn_type = 'CR' And sal =
(Select max(sal) From cust_data) And Rownum = 1;
Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
how can we store any pdf file in oracle
What is a lookup table in oracle?
What are the advantages of oracle 12c?
Explain the use of indexes option in imp command.
How would you go about verifying the network name that the local_listener is currently using?
What is meant by an index?
What do you mean by merge in oracle?
What is a nvl function? How can it be used?
Is a rollback possible to any savepoint?
What is the order of defining local variables and sub procedures/functions?
Explain self joins in oracle?
what are bitmap indexes? How does they work?
Is oracle a programming language?
What are the various oracle database objects?
Please explain joins in oracle?