1)select dept from E where sal=(select max(sal) from E where month='

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?

Question Posted / venkateswara reddy

6 Answers
7191 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

Please Help Members By Posting Answers For Below Questions

What is a private synonym?

1531

Explain self joins in oracle?

951

Explain the use of compress option in exp command.

969

What is an oracle recycle bin?

932

Explain alias?

1081

Point the difference between translate and replace?

1028

Explain an exception?

923

Explain an integrity constrains?

1085

How to manage transaction isolation level?

951

What is Trigger in Oracle?

1076

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2251

Explain about the analyze command in oracle?

998

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1790

if you ctreate table identity

2316

How to retrieve values from data fields in record variables?

1036