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
- 6419 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a private synonym?
why dont we assign not null constraint as table level constraint.
Explain oracle 12c new features for developers?
What is set verify off in oracle?
What are the attributes of the cursor?
What is a cursor and what are the steps need to be taken?
Design database draw er diagram for a certain scenario ?
What is recovery manager(rman) backup in Oracle?
Explain user account with reference to oracle.
What is tns entry?
What is a table index?
How to create a new view in oracle?
How to generate query output in html format?
How do I connect to oracle?
Explain joins in oracle?
