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

How to define and use table alias names in oracle?

995

Can we protect our pl/sql source code?

1084

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2426

Difference between oracle's plus (+) notation and ansi join notation?

1160

List out the types of joins.

1243

How to see free space of each tablespace?

1084

How do I know if oracle client is installed on windows?

1097

What is backup in Oracle?

1082

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1980

How to use "for" statements in oracle?

1126

Explain the difference between sql and oracle?

1127

How to generate query output in html format?

1214

Can we store pictures in the database and if so, how it can be done?

1092

what is the difference between substr and instr function in oracle?

1143

Why do you use stored procedures and state some of its disadvantages?

1080