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
- 12423 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 kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Design time, run time. If you don't create parameter what will happen
What is a sequence generator transformation?
How to join three sources using joiner? Explain though mapping flow.
How to update or delete the rows in a target, which do not have key fields?
What do you understand by a term domain?
explain about unit testing? in real time?
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain transaction control transformation in informatica
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to load data in informatica ?
How to create the source and target database connections in server manager?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What does reusable transformation mean?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
