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
- 12738 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 sql transformation in script mode examples in informatica
What is target designer and target load order?
What are the types of lookup transformation?
What is the reusable transformation?
Different circumstance which drives informatica server to expel records?
Define filter transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Differentiate between source qualifier and filter transformation?
Which files are created during the session rums by informatics server?
What is a joiner transformation and why it is an active one?
How does a sorter cache works?
Please let me know how to make Data masking in informatica..
Informatica settings are available in which file?
What is meant by lookup transformation?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
