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

Explain the use of indexes option in imp command.

1264

Explain oracle 12c new features for developers?

1126

What is the best way to do multi-row insert in oracle?

1108

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1089

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

2049

What is oracle database 10g express edition?

1172

What is oracle datasource?

1041

How to view the data files in the current database?

1152

What are the limitations of check constraint?

1076

How to end the current transaction in oracle?

1072

Explain how you would restore a database using RMAN to Point in Time?

2188

Can we store images in oracle database?

1068

What is define in oracle?

1112

What is an oracle transaction?

1229

How data locks are respected in oracle?

1113