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
- 7828 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 add another datafile to a tablespace?
How do I spool to a csv formatted file using sqlplus?
What happens if the update subquery returns multiple rows?
What is the relationship among database, tablespace and data file?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
what's query optimization and without use of IN AND Exist can we get another way data from query
How to declare a local variable?
Differentiate between pre-select and pre-query?
How to bring a tablespace offline?
What is blob datatype?
What is different types of joins?
What is archive log in Oracle?
How to see the table columns used in an index?
What is a proxy object?
What is sharded cluster?
