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
- 5729 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / venkateswara reddy
1)select dept from E where sal=(select max(sal) from E where
month='JAN')
2)select dept from E where sal=(select max(sal) from E)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
List out the difference between commit, rollback, and savepoint?
what are archived logs?
How to drop an index?
How much memory your 10g xe server is using?
What is a data lock in oracle?
Whether any commands are used for months calculation? If so, what are they?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
Give the advantages and disadvantages of clusters.
What is the sql query to concatenate column values from multiple rows in oracle?
Difference between pre-select and pre-query
How to create an oracle database?
What are the different types of modules in oracle forms?
How to turn on or off recycle bin for the instance?
What are the differences between date and timestamp in oracle?
How to assign values to data fields in record variables?
