select dept from ( select dept, max(sal) over()

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 / suman rana

6 Answers
7251 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / suman rana

select dept from ( select dept,
max(sal) over() maxsal,
sal from ( select dept,
max(sal) sal
from E
where month=JAN'
group by dept
)
) WHERE maxsal = sal;

select distinct dept from ( select dept, max(sal) over ()
maxsal, sal
from E
)
where maxsal = sal;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is oracle instant client?

986

What is not equal to in oracle?

961

What is a initialization parameter file in oracle?

1000

What is an oracle function?

1101

Which are the five query types available in oracle?

919

what is difference between sql plus and sql*plus? (not sql and sql plus).

3841

How to use in conditions in oracle?

1013

How to create a single index for multiple columns?

992

Describe the types of sub query?

954

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.

2329

What is flashback in Oracle?

986

What is sharded cluster?

961

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2306

Can you drop an index associated with a unique or primary key constraint?

981

Explain a synonym?

987