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
7649 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 are the set operators union, union all, minus & intersect meant to do?

1038

How to create a server parameter file?

1188

Explain the use of owner option in exp command.

1102

How to filter out duplications in the returning rows using oracle?

1068

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2288

Explain oracle data types with examples?

1081

Explain database link?

1176

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1935

What is the difference between post-database commit and post-form commit?

1288

How can we delete duplicate rows in a table?

1041

What are the benefits of ordbms?

1141

What exactly do quotation marks around the table name do?

1027

Difference between the “verify” and “feedback” command?

1429

What is java oracle used for?

1081

What is the relation of a user account and a schema?

1181