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

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the Tune Query

2235

query optmization techniques and quwry analyser+projects+ppts

2372

Explain what does a control file contain?

1034

How to loop through a cursor variable?

1014

What is the database name in oracle?

972

What are privileges and grants?

1003

What is an index associated with a constraint?

975

How to start your 10g xe server?

971

What is a server parameter file in oracle?

1004

How to install oracle odbc drivers?

1041

What operating systems are supported by oracle database 10g xe?

985

Why should I use oracle database?

948

Can we create database in oracle using command line ?

1031

How can I combine multiple rows into a comma-delimited list in oracle?

1001

Is oracle an operator?

885