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
- 7430 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / suman rana
select dept from ( select dept,
max(sal) over() maxsal,
sal from ( select dept,
max(sal) sal
from E
where month=JAN'
group by dept
)
) WHERE maxsal = sal;
select distinct dept from ( select dept, max(sal) over ()
maxsal, sal
from E
)
where maxsal = sal;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What is meant by recursive hints in oracle?
What is the relationship among database, tablespace and data file?
What is Reduced List of Values?
What is a initialization parameter file in oracle?
Describe varray?
How can Oracle users be audited?
How to convert character types to numeric types?
What is a nvl function?
How to rename an index?
Name the three major set of files on disk that compose a database in Oracle?
candidate key is subset of super key but not vice-verse explain
How to use an explicit cursor without open statements?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
how may join possible between (requisition with purchase order)
