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
- 11055 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
What are the uses of etl tools?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is informatica powercenter repository?
what is INFORMATICA TESTING process
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
How would you copy the content of one repository to another repository?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is domain and gateway node?
How union transformation is used?
have u done any performance tuning? how u ll do?
Explain joiner transformation in informatica
What are ETL Tools?
How to load data in informatica ?
where to store informatica rejected data? How to extract the informatica rejected data?
