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
- 8960 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / rakesh
select deptno, sum(sal) from emp group by deptno having sum(sal)>(select avg(sum(sal)) from emp
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Differentiate between a database and data warehouse?
How do you convert single row from source into three rows into target?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Define the various join types of joiner transformation?
What is the command used to run a batch?
What are the features of complex mapping?
What are the informatica performance improvement tips
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is parallel processing in informatica?
How can you increase the performance in joiner transformation?
What are active and passive transformations?
What are the measure objects?
What are the types of presistent cache in look up tr.
Write the different tools in the workflow manager?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
