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 / aswini
select * from <table_name> where salary in(select max
(salary) from <table_name>);
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the common oracle dba tasks?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
What is the difference between sharding and partitioning?
What are dml statements in oracle?
What is define in oracle?
Explain a synonym?
What are the uses of a database trigger?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is tns entry?
What are the parameters that we can pass through a stored procedure?
List out the types of joins.
Which is better Oracle or MS SQL? Why?
What is a proxy class?
Hi Can any one tell me what are the API's used in requisition import.
How do I learn what codesets are available in oracle?