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?
Answer Posted / mayur
select max(sal) from e where sal in (select month form e
where month = 'JAN';
Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
How to convert characters to dates in oracle?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What is ADDM Advisor in Oracle?
What is translate in oracle?
What is logical backup in oracle?
How to get last row id?
What is the difference between post-database commit and post-form commit?
What is Library Cache in Oracle?
Is oracle a language?
What is max rowid in oracle?
How do I recompile a procedure in oracle?
How to check your oracle database 10g xe installation?
Where is the export dump file located?
What is connection pool in oracle?
What is the difference between alert log file and tarce file ?