select deptno,sum(sal) from emp group by deptno having sum(Sal) =(select m

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

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

Answer Posted / ravikishore

select deptno,sum(sal) from emp group by deptno having
sum(Sal) =(select max(sum(sal)) from emp group by deptno)

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

can anyone suggest best free Talend data integration training online

1691

Define sessions in informatica etl?

1035

How can repository reports be accessed without sql or other transformations?

1220

Explain the pipeline partition with real time example?

1144

How can we store previous session logs?

1083

What do you understand by a term domain?

1125

What is native users?

1167

is it possible to index the data in cache of lkp transformation ?

2029

what is the -ve test case in your project.

2407

What is Index Caches size?

1116

Tell me about MD5 functions in informatica

929

lookup transformation with screenshots

4006

What do you mean incremental aggregation?

1076

When do you use sql override in a lookup transformation?

1099

Explain joiner transformation in informatica

1124