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

Which is faster join or subquery in oracle?

995

What is transaction control statement and how many types of transaction control statement in Oracle?

1159

Describe varray?

1059

Describe an oracle table?

1050

What is the difference between substr & instr functions?

1229

What is a read only transaction in oracle?

1029

What is object data modeling?

969

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2180

What are triggers in oracle?

1040

How to execute a stored program unit?

1077

Is oracle a programming language?

990

How to invoke the original export import utilities?

1064

What are the various oracle database objects?

1145

What is oracle database client?

1033

What is open database communication (odbc) in oracle?

1003