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
- 8924 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 group by deptno);
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
waht type of interface is used for testing the data in informatica
What are the limitations of joiner transformation?
Mention a few design and development best practices for informatica?
Differentiate between source qualifier and filter transformation?
What is a predefined event?
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.
During the running session, output files are created by informatica server. Enlist few of them.
Is stop and abort are same in informatica?
What is the difference between informatica 7.0 and 8.0?
What is domain in terms of informatica?
What is the benefit of partitioning a session?
How do you load alternate records into different tables through mapping flow?
Can you use flat files in Mapplets.
In development project what is the process to follow for an etl developer from day1
What is the use of an aggregator cache file?
