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
7433 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

How to check the oracle tns settings?

1047

What are the logical operations?

1126

Differentiate between function and procedure in oracle.

1083

How many data types are supported?

1083

Is oracle an open source?

1083

Can we create database in oracle using command line ?

1091

How to do paging with oracle?

1003

Give the constructs of a package, function or a procedure.

1046

What is a connect identifier?

1042

what is port in oracle? how is it related to database application.

1949

List the parts of a database trigger.

1053

How to rollback the current transaction in oracle?

1056

What happens to the current transaction if the session is ended?

1098

How to convert raw data type into text in oracle? Explain

993

Explain an exception?

1003