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 / srikanth
select *from <TN>
where sal=(select max(sal) from <TN>);
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to update a table row with a record?
What is set operator oracle?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
what is the difference between restoring and recovering?
What are the differences between char and varchar2 in oracle?
What is a snapshot in oracle database?
What are the types of partitions in oracle?
What is index in Oracle?
How to start an oracle instance?
What do you mean by a tablespace?
What is a parameter file in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to check database size in Oracle?
How to manage transaction isolation level?
State the difference between a primary key and foreign key?