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

What happens if you set the sga too low in oracle?

1085

What are privileges and grants?

1019

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4492

What is an oracle cursor variable?

1028

Query to retrieve record for a many to many relationship ?

2477

What is SQL access advisor in Oracle?

1158

What is hot backup and logical backup?

1020

Can we use bind variables in oracle stored procedure?

918

Explain the use of online redo log files in oracle.

1011

How to loop through data rows in the implicit cursor?

1034

Can multiple cursors being opened at the same time?

1036

What do you understand by database schema and what does it hold?

1198

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

1966

How to login to the server without an instance?

1128

Explain table?

1083