Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 11212 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / moorthy g
select deptno, max(sal) from emp group by deptno
having max(sal)> (select avg(max(sal)) from emp group by
deptno);
Output:
DEPTNO MAX(SAL)
---------- ----------
10 5000
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is union transformation in informatica?
How do you promote a non-reusable transformation to reusable transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
can we override a native sql query within informatica? Where do we do it?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What do you mean by blocking transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are batches?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What are multi-group transformations?
What is DR strategy for Informatica project?
What are the popular informatica products?
How to load the data from people soft hrm to people soft erm using informatica?
Did u used latest transformations of 8.6.0? for what?
