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
7424 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 operating systems are supported by oracle database 10g xe?

1034

How do you tell what your machine name is and what is its IP address?

2097

State any two functions of oracle?

1046

What is ceil and floor in oracle?

1070

What is difference between truncate and delete?

1040

What happens if the imported table already exists?

1033

How do I connect to oracle database?

1119

What are the different windows events activated at runtime ?

2900

Explain a private synonyms?

1039

What is a schema in oracle?

1014

How to compare dates in oracle sql?

1105

How a tablespace is related to data files?

1109

How to shutdown your 10g xe server from command line?

1087

How to define default values for formal parameters?

1044

Explain user account with reference to oracle.

990