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
7267 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 transaction control statement and how many types of transaction control statement in Oracle?

1105

What is redo log?

1022

How to change program global area (pga) in oracle?

1049

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2233

State the difference between a primary key and foreign key?

905

Describe the types of sub query?

962

How to bring a tablespace online?

1027

How to create an oracle database manually?

1045

How can I get column names from a table in oracle?

1008

How many types of synonyms in Oracle?

1087

Explain the dml?

936

What is SQL Tuning Advisor in Oracle?

1127

what is meant by magic query

2149

How can windows applications connect to oracle servers?

1014

What are a cluster and non-cluster index?

983