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
- 10560 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
Which transformation is needed while using the Cobol sources as source definitions?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What does “tail –f” command do and what is its use as an Informatica admin.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is workflow manager?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
difference between repository database and repository service?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What are the different types of transformation available in informatica.
What is meant by LDAP users?
What is the different lookup cache(s)?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain in detail scd type 2 through mapping.
What are the prerequisite tasks to achieve the session partition?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
