select max(sal) from e where sal in (select month form 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 / mayur

6 Answers
7448 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / mayur

select max(sal) from e where sal in (select month form e
where month = 'JAN';

Is This Answer Correct ?

0 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain the use of Merge statement in oracle 11g

1035

What is a synonym? What are its various types?

1119

What is the exact use of Collections?

2148

How to pass a cursor variable to a procedure?

1118

What do you mean by a deadlock?

1070

What is SQL Tuning Advisor in Oracle?

1188

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2025

Explain a data segment?

1079

Why do we need integrity constraints in a database?

1030

How to delete a user account in oracle?

989

What is the usage of analyze command in oracle?

1104

What are the types of trigger in oracle?

993

Please explain compound trigger in oracle?

1069

What is a trigger oracle?

1096

What are the original export and import utilities?

1185