select deptno, sum(sal) from emp group by deptno having sum(sal)>(select

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

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

Answer Posted / rakesh

select deptno, sum(sal) from emp group by deptno having sum(sal)>(select avg(sum(sal)) from emp group by deptno);

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is resilience time?

1227

Define joiner transformation?

1107

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2193

Is stop and abort are same in informatica?

1048

How many dimensions are there in informatica?

1135

What are some examples of informatica etl programs?

988

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

1067

draw informatica architecture 8.6 ?

3931

Explian the Process of deployment groups in informatica

1102

What are the restrictions of union transformation?

1088

As union transformation gives UNION ALL output, how you will get the UNION output?

1159

What you know about transaction control transformation?

1059

Mention some types of transformation?

1097

How to load data in informatica ?

1070

What is a router transformation?

1213