There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department.
Write a query
- 7 Answers
- 10524 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / murali krishna udayagiri
SELECT E.* FROM EMP E ,(SELECT DEPTNO,AVG(SAL) AVGSAL FROM
EMP GROUP BY DEPTNO) E1
WHERE E.SAL>E1.AVGSAL
AND E.DENPTNO=E1.DEPTNO;
Thanks,
Murali Udayagiri
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
in reporting we add some new objects,how we get the count of the newly added objects to the report
How do you take back up of repository?
What are the components of the workflow manager?
What are the performance considerations when working with aggregator transformation?
How can we use batches?
can anyone suggest best free Talend data integration training online
What are the tasks that source qualifier perform?
What is rank transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are the databases that informatica can connect to windows?
Performance tuning( what you did in performance tuning)
Implementation methodology
Under what conditions selecting sorted input in aggregator will still not boost session performance?
