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
- 10561 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sri
SELECT *FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP WHERE
DEPTNO=10);
| Is This Answer Correct ? | 4 Yes | 6 No |
Post New Answer View All Answers
Which development components of informatica have the highest usage?
How can informatica be used for an organization?
what is the size of u r source(like file or table)?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Reusable transformation and shortcut differences
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How do you handle two sessions in Informatica
How to elaborate powercenter integration service?
Suppose we do not group by on any ports of the aggregator what will be the output?
How does the aggregator transformation handle null values?
What happens when a session fails and you click on recover?
Different qualification between a related rotate toward the sky and isolates look upward?
update strategy transformation in informatica
What is an Integration service in Informatica?
