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

What is ASM (Automatic Storage Management) in Oracle?

1247

Why cursor variables are easier to use than cursors?

1146

Explain an exception and its types?

1141

Explain the characteristics of oracle dba?

1180

How to add a new column to an existing table in oracle?

1192

How to assign values to variables?

1168

How to lock and unlock a user account in oracle?

1164

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

2002

Explain the use of rows option in imp command.

1143

What do you know about normalization? Explain in detail?

1005

What do you mean by merge in oracle and how can we merge two tables?

1097

What are the arithmetic operations?

1154

How do I manually uninstall oracle client?

1154

What is a select query statement in oracle?

1033

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2198