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
7416 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 trigger and what are its types?

1226

Why do we use coalesce function in oracle?

1118

Explain the use of grant option in exp command.

1063

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

1840

What is Library Cache in Oracle?

1142

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1947

what is reindexing?

1671

What happens to the indexes if a table is recovered?

993

Can we call procedure inside function in oracle?

1086

Does facebook use oracle?

1031

Where is the export dump file located?

1152

Can we protect our pl/sql source code?

1042

Briefly explain what is literal? Give an example where it can be used?

1037

What is the scope of a local variable?

1065

What is a dynamic performance view in oracle?

990