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
- 6005 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / er mahesh shiv gaur
SELECT MAX(SALARY) FROM (SELECT FIRST_NAME,SALARY,FROM EMP
ORDER BY SALARY DESC) WHERE ROWNUM<=1 GROUP BY
FIRST_NAME,SALARY;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to unlock the sample user account in oracle?
What is oracle in java?
How to create a single index for multiple columns?
What are the different types of synonyms?
Explain the use of rows option in imp command.
How to export your own schema?
What is ceil and floor in oracle?
Explain the use of log option in exp command.
Explain the use of inctype option in exp command.
What is parameterized cursor in oracle?
How to delete an existing row from a table in oracle?
How to check database size in Oracle?
How to define a variable to match a table column data type?
What is Undo Management Advisor in Oracle?
What is ADDM Advisor in Oracle?
