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
11044 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 dynamic cache?

1036

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2358

in reporting we add some new objects,how we get the count of the newly added objects to the report

2195

How can we store previous session logs?

1083

What is rank transform?

997

Which transformation should we use to normalise the COBOL and relational sources?

1213

differences between service based and product based?

2015

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1710

In informatica workflow manager, how many repositories can be created?

1363

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2057

How we can use union transformation?

1051

What are the components of workflow manager?

1101

Clarify the aggregator change?

1030

What is the advantage of informatica?

1069

Different sorts of metadata that stores in the storage facility?

1012