Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 7823 Views
- Wipro, I also Faced
- E-Mail Answers
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
Explain how you would restore a database using RMAN to Point in Time?
What is oracle host variable?
Can select statements be used on views in oracle?
what are the default admin accounts in Oracle 10g ?
Can sub procedure/function be called recursively?
What happens if the imported table already exists?
How to change system global area (sga) in oracle?
What is an oracle user account?
What is an Oracle index?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to select some columns from a table in oracle?
What are the advantages of oracle?
Can group functions be mixed with non-group selection fields?
Explain an index?
what is the difference between functional dependecy and multilevel dependency?
