select deptno,sum(sal) from emp group by deptno having sum(Sal) =(select m

Write a query to display Which deptno is containing highest
Sal > avg (sum (Sal)) of all deptno;

Avg (sum (Sal)) o f all deptno= 9675
Deptno, sum (Sal)
10 8750
20 10875
30 9400

Question Posted / ravikishore

7 Answers
10781 Views
iGate, I also Faced
E-Mail Answers

Answer Posted / ravikishore

select deptno,sum(sal) from emp group by deptno having
sum(Sal) =(select max(sum(sal)) from emp group by deptno)

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the conditions needed to improve the performance of informatica aggregator transformation?

1038

What are the types of data warehouses?

1431

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2062

Describe expression transformation?

1045

What is informatica? Why do we need it?

1041

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2681

How can we store previous session logs?

992

What is aggregator transformation in informatica?

899

What is the maplet?

1041

What are data-driven sessions?

1145

What are the components of the workflow manager?

1083

What is the cumulative sum and moving sum?

1139

How do you load unique records into one target table and duplicate records into a different target table?

1166

What is pmcmd command?

1049

What is the meaning of decode in informatica?

1076