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
- 11227 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / ravikishore
select deptno,sum(sal) from emp group by deptno having
sum(Sal) =(select max(sum(sal)) from emp group by deptno)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How do you take back up of repository?
What are the guidelines to be followed while using union transformation?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Which is the t/r that builts only single cache memory?
What the difference is between a database, a data warehouse and a data mart?
Can we create a Integration service without a Repository service and vice versa?
What is the need of an ETL tool?
Can informatica load heterogeneous targets from heterogeneous sources?
What is lookup change?
How can we use mapping variables in informatica? Where do we use them?
Describe an informatica powercenter?
If informatica has its scheduler why using third party scheduler?
Where is metadata stored?
explan ur project architecture?
expain about the tune parameters?
