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
- 11213 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / jz
select deptno,max(sal) from emp
group by deptno
having max(sal)>(select avg(sum(sal) )from emp
group by deptno)
:)
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Different circumstance which drives informatica server to expel records?
What do you understand by term role-playing dimension?
As union transformation gives UNION ALL output, how you will get the UNION output?
tell me the rules and responsblites in our project(my project is development)
Suppose we do not group by on any ports of the aggregator what will be the output?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How we can create indexes after completing the loan process?
Explain target update override in informatica
Why union transformation is an active transformation?
What are some examples of informatica etl programs?
What are the different options available for update strategy?
EXL informatica Questions
What is a grid in Informatica?
explain one complex mapping with logic? sales project?
Which transformation is needed while using the Cobol sources as source definitions?
