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
Answer Posted / jz
select deptno,max(sal) from emp
group by deptno
having max(sal)>(select avg(sum(sal) )from emp
group by deptno)
:)
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Name the different lookup cache(s)?
What are the performance considerations when working with aggregator transformation?
What will be the approach?
What is joiner transformation in informatica?
What is a connected transformation?
permutations of mapplet
can we override a native sql query within informatica? Where do we do it?
Explain the pipeline partition with real time example?
How do you change a non-reusable transformation to reusable transformation?
What are the different lookup cache(s)?
What is the function of look up transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What does update strategy mean, and what are the different option of it?
Explain what are the different versions of informatica?