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
- 8125 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 load data from external tables to regular tables?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
Explain the use of inctype option in exp command.
How to retrieve data from an explicit cursor?
What are the various constraints used in oracle?
What are advantages of dateset in datastage?
What is Reduced List of Values?
How to initialize variables with default values?
how to do daily transactions with out sql* loader control file regesterd in apps?
What is an oracle data file?
What is the relationship among database, tablespace and data file?
Can you drop an index associated with a unique or primary key constraint?
Please explain compound trigger in oracle?
Where are the settings stored for each instance in oracle?
