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
- 11054 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 dimensional table?
What is the session task and command task?
What are batches?
What are mapplets? How is it different from a Reusable Transformation?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is a surrogate key?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How an expression transformation differs from aggregator transformation?
What is a grid in Informatica?
How is union transformation utilized?
How do you load only null records into target?
How to handle decimal places while importing a flatfile into informatica?
what is INFORMATICA TESTING process
Write the prerequisite tasks to achieve the session partition?
How to join three sources using joiner? Explain though mapping flow.
