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
- 8961 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
What is the cumulative sum and moving sum?
What is the difference between stop and abort in informatica
What are the steps involved in the migration from older version to newer version of Informatica Server?
Which transformation is needed while using the Cobol sources as source definitions?
What is a dimensional model?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explian the Process of deployment groups in informatica
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How are indexes created after completing the load process?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
How to go to the older version for a mapping?
what is Active lock explain
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How to implement security measures using repository manager?
Mention few power centre client applications with their basic purpose?
