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
- 8109 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
What is bind variable in oracle 11g?
Is oracle a language?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How do I find my oracle client driver version?
What is a nvl function? How can it be used?
How to use in conditions in oracle?
What is a private synonym?
What is oracle instant client?
What are the attributes that are found in a cursor?
Difference between open_form and call_form in oracle.
What is meant by an index?
What is a schema in oracle?
How to create a table in a specific tablespace?
What are the limitations oracle database 10g xe?
State some uses of redo log files?
