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 / 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
What is xml source qualifier transformation in informatica?
Describe the impact of several join conditions and join order in a joiner 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 the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the differences between source qualifier and joiner transformation?
How would you join a node to the already existing domain?
What is the function of look up transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
Please let me know how to make Data masking in informatica..
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the issues you have faced in your project? How did you overcome those issues?
What are the mapping parameters and mapping variables?
without table how to come first record only in oracle?
What is meant by a domain?
What are ETL Tools?