select department_ID, sum(salary) from emp group by department

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 / aashish

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

Answer Posted / aashish

select department_ID, sum(salary) from emp group by department_ID having sum(salary) > (select avg(sum(salary)) from emp group by department_ID);

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Describe expression transformation?

1169

Plz can any one say me how to get the informatica certification materials and dumps

2099

What are multi-group transformations?

1165

Explain the informatica workflow?

1127

What is rank transform?

1061

How can you increase the performance in joiner transformation?

1248

What are the different types of transformation available in informatica.

1145

Separate from an archive server and a powerhouse?

1008

Mention some types of transformation?

1096

What is a filter transformation?

1092

How to start a workflow using pmcmd command?

1306

What is meant by target load plan?

1029

Which means the first record should come as last record and last record should come as first record and load into the target file?

1142

Which are the different editions of informatica powercenter that are available?

1080

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

1166