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
- 12701 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
Briefly define a session task?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Differences between connected and unconnected lookup?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
In informatica workflow manager, how many repositories can be created?
What happens when a session fails and you click on recover?
What are the databases that informatica can connect to windows?
what is the size of u r source(like file or table)?
Different circumstance which drives informatica server to expel records?
What is the difference between Active and Passive transformation?
What are the restrictions of union transformation?
what is the -ve test case in your project.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Differentiate between Load Manager and DTM?
What is the procedure for creating independent data marts from informatica 7.1?
