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

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

What is a snowflake schema?

996

Define filter transformation?

1103

what is $$$$?

2163

In how many ways we can create ports?

1123

Can we create a Integration service without a Repository service and vice versa?

1215

Can we create multiple integration service on single repository?

1189

Explain the code page compatibility?

1072

Explain constraint based loading in informatica

1098

What are the different types of olap? Give an example?

1057

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237

Which version configuration tool used in ur project?

3262

what is INFORMATICA TESTING process

2296

How many ways a relational source definition can be updated and what are they?

1019

Can we create a node as a gateway node and the same node can be assigned to a grid?

1082