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
- 7921 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 the disadvantage of User defind function?
What is a read only transaction in oracle?
Which is better Oracle or MS SQL? Why?
How to declare a local variable?
What are the differences between date and timestamp in oracle?
What is Java Pool in Oracle?
How index is implemented in oracle database?
Is a rollback possible to any savepoint?
What is oracle open database communication (odbc)?
Explain what are synonyms used for?
How to see the table columns used in an index?
What is rowid and rownum in oracle?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to speed up webrick?
How would you go about verifying the network name that the local_listener is currently using?
