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
- 8927 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / aashish
select department_ID, sum(salary) from emp group by department_ID having sum(salary) > (select avg(sum(salary)) from emp group by department_ID);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the shared cache and re-cache?
What is a filter transformation?
Differences between version 7.x and 8.x.
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What are session parameters ? How do you set them?
Design a mapping to load a target table with the following values from the above source?
Difference between Target-based loading and constraint-based loading?
What is aggregator transformation in informatica?
Explain sessions?
How to join three sources using joiner? Explain though mapping flow.
Describe data concatenation?
What are the performance considerations when working with aggregator transformation?
What are the main features of Oracle 8i with context to datawarehouse?
How to update or delete the rows in a target, which do not have key fields?
What is meant by lookup transformation?
