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
- 12507 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
Can u generate reports in Informatica?
What is aggregate cache in aggregator transformation?
what is the size of u r source(like file or table)?
What is the benefit of partitioning a session?
What are the uses of etl tools?
how to load dimension table and fact table. plz tell me the steps.
What is meant by pre and post session shell command?
What is a connected transformation?
What are the different types of olap? Give an example?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Whats there in global repository
What are the limitations of joiner transformation?
What is meant by LDAP users?
What is complex mapping?
What is the use of code page?
