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
- 7449 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / parag
1) SELECT DISTINCT DEPT FROM TABLE
WHERE SAL >=
(SELECT MAX(SAL) FROM TABLE
WHERE MONTH = 'JAN');
2) SELECT DISTINCT DEPT, SAL FROM TABLE
WHERE SAL >=
(SELECT MAX(SAL) FROM TABLE);
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / 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 |
Answer / 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 |
Answer / shilpa
1) select dept , max(sal) from E where month=JAN';
2) select dept , max(sal) from E ;
| Is This Answer Correct ? | 1 Yes | 3 No |
Answer / mayur
select max(sal) from e where sal in (select month form e
where month = 'JAN';
| Is This Answer Correct ? | 0 Yes | 5 No |
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How many types of auditing in Oracle?
Explain what are synonyms used for?
Can you create a synonym without having a table?
Can you drop an index associated with a unique or primary key constraint?
what is cartesian product?
What is a deadlock in SQL? How can you prevent it?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
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.
what is the output of select * from emp where null=null & select * from emp where 1=1
Explain joins in oracle?
Respected sir, Please send me technical questions related to oracle apps..
Oracle General 
