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
- 10557 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ram
SELECT * FROM emp e WHERE sal > (SELECT AVG(sal) FROM emp m
WHERE e.deptno = m.deptno GROUP BY deptno) ORDER BY deptno
gives u salary greater than the average salary of their
departments...
| Is This Answer Correct ? | 22 Yes | 4 No |
Post New Answer View All Answers
What are the types of lookup transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
my source is junk data how will u remove that junk data by using unix please any one replay me
What is transformation?
Write the different tools in the workflow manager?
Whats there in global repository
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How do you load unique records into one target table and duplicate records into a different target table?
What is the procedure for creating independent data marts from informatica 7.1?
What is a filter transformation and why it is an active one?
Where are the source flat files kept before running the session?
How many types of sessions are there in informatica.please explain them?
Please let me know how to make encryption and decryption with example?
What is option by which we can run all the sessions in a batch simultaneously?
