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
- 11220 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / rakesh
select deptno, sum(sal) from emp group by deptno having sum(sal)>(select avg(sum(sal)) from emp
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What are the differences between joiner transformation and source qualifier transformation?
How identifying bottlenecks in various components of informatica and resolving them?
whats the logic to load the lower level of granularity of data to fact table.
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
Briefly define reusable transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is complex mapping?
What is joiner transformation in informatica?
Why is sorter an active transformation?
what is index?how it can work in informatica
What is the command used to run a batch?
What are the restrictions of union transformation?
Design a mapping to load a target table with the following values from the above source?
Tell me about Propagate functions in informatica
Write the different tools in the workflow manager?
