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
- 5988 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
Why oracle is used?
How to load a large xml file?
Who developed oracle & when?
Can I create users through internet explorer in oracle 10g?
How to put more than 1000 values into an oracle in clause?
How to select some rows from a table in oracle?
How to see free space of each tablespace?
what is the use of system.effective.date variable in oracle?
What is transport network substrate (tns) in oracle?
Is there an oracle sql query that aggregates multiple rows into one row?
What do you mean by cdb and pdb in oracle 12c?
What happens to the current transaction if a ddl statement is executed?
What is blob data type in oracle?
How do I recompile a procedure in oracle?
Explain the types of exception?
