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 install oracle database 10g xe?
What is Reduced List of Values?
What is a package in oracle?
What is the difference between post-database commit and post-form commit?
What are the execution control statements in oracle?
What's dateware house and what's clustor with practicle example
What happens to the data files if a tablespace is dropped?
How does Oracle guarantee data integrity of data changes?
Explain what are the characteristics of data files?
How to loop through a cursor variable?
What are a query and state the different types of queries and their uses?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How view is different from a table?
What is oracle used for?
What is an oracle database?