Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12912 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
Explain the difference between a data warehouse and a data mart?
As union transformation gives UNION ALL output, how you will get the UNION output?
What are the performance considerations when working with aggregator transformation?
What is intricate mapping?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How to elaborate tracing level?
Which are the different editions of informatica powercenter that are available?
To import the flat file definition into the designer where should the flat file be placed?
Define Pmrep command?
Explain the types of transformations?
What does reusable transformation mean?
What will be the approach?
What is joiner transformation?
server hot-ws270 is connect to Repository B. What does it mean?
How to go to the older version for a mapping?
