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

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define joiner transformation?

1049

Difference between Data and Index Caches?

1137

What is rank transformation in informatica

1179

explain about unit testing? in real time?

2205

What are the differences between source qualifier and joiner transformation?

1062

What do you mean by blocking transformation?

1037

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

2146

What are the new features of informatica 9.x in developer level?

998

Differentiate between a repository server and a powerhouse?

1118

What does refresh system mean, and what are its distinctive choice?

1179

draw informatica architecture 8.6 ?

3871

What is the difference between writing a joiner query in ANSI style and THETA style?

2379

How we can create indexes after completing the load process?

1160

State the differences between sql override and lookup override?

1207

What are pre and post-session shell commands?

1311