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

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1870

How to go to the older version for a mapping?

602

How many ways are there to do 'remove duplicate records in informatica'?

585

What are the prerequisite tasks to achieve the session partition?

713

server hot-ws270 is connect to Repository B. What does it mean?

1855

How to do unit testing in informatica? How to load data in informatica ?

648

What all are steps in up gradation of Informatica server?

620

Explain joiner transformation in informatica

666

Define update strategy?

637

Explain pmcmd command usage in informatica

703

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1634

What is the sql query overwrite in source qualifier in informatica

617

Explain the code page compatibility?

641

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1642

Explain in detail about scd type 1 through mapping.

589