Interested to Buy Any Domain ? << Click Here >> for more details...
Table E:
Name dept month sal
1 A JAN 800
2 B APR 1000
3 A JAN 300
4 A JAN 600
5 C JUN 400
1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH?
2) WRITE QUERY GET MAX SAL DEPT NO?
- 6 Answers
- 7190 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / shilpa
1) select dept , max(sal) from E where month=JAN';
2) select dept , max(sal) from E ;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What's dateware house and what's clustor with practicle example
What is the usage of save points in oracle database?
How to do clean up if create database failed?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
What are the different types of record groups in oracle? Explain each of them
Will you be able to store pictures in the database?explain.
What is the string concatenation operator in oracle?
How to bring a tablespace offline?
How to drop a stored procedure in oracle?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
What do you mean by redo log file mirroring?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
What is an index associated with a constraint?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to do a full database export?
