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
- 8948 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
Differentiate between sessions and batches?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to do unit testing in informatica? How to load data in informatica ?
What does reusable transformation mean?
What is the use of source qualifier?
What are the components of Informatica? And what is the purpose of each?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How can we remove the duplicates from flat file source?
Tell me about MD5 functions in informatica
What is the use of an aggregator cache file?
What is parallel processing in informatica?
What is transformation?
Write the advantages of partitioning a session?
how to create user defined function (udf) in informatica
What is the need of etl tools?
