1) select dept , max(sal) from E where month=JAN'; 2) select dept , m

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 / shilpa

6 Answers
7431 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / shilpa

1) select dept , max(sal) from E where month=JAN';
2) select dept , max(sal) from E ;

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to assign values to variables?

1108

How to convert characters to dates in oracle?

1103

Explain the use of ignore option in imp command.

1035

What is the usage of synonyms?

1143

What is SQL Tuning Advisor in Oracle?

1183

Explain the different normalization forms?

1107

Which is better Oracle or MS SQL? Why?

6390

Explain the function of optimizer in oracle?

1145

How to use "while" statements in oracle?

1327

How to pass parameters to procedures in oracle?

1042

Please explain drop constraint oracle?

1112

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2316

How to drop an index?

962

what is meant by magic query

2188

Which are the five query types available in oracle?

949