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
- 11027 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 reusable transformation and mapplet.
What does cheating measurement mean?
Can you generate sequence numbers without using the sequence generator transformation?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
is it possible to index the data in cache of lkp transformation ?
Explain the types of transformations?
How can repository reports be accessed without sql or other transformations?
What are some examples of informatica etl programs?
what is index?how it can work in informatica
What are the new features of informatica 9.x in developer level?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
have u done any performance tuning? how u ll do?
How do you remove duplicate records in informatica? And how many ways are there to do it?
How we can use union transformation?
What is xml source qualifier transformation in informatica?
