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
- 12431 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vivek singh
SELECT * FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP)
AND DEPTNO=10;
O/P:
7839 KING PRESIDENT 17-NOV-81 5000 10
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Performance tuning( what you did in performance tuning)
What is the different lookup cache(s)?
How many input parameters can exist in an unconnected lookup?
What all are steps in up gradation of Informatica server?
What do mean by local and global repository?
How we can create indexes after completing the loan process?
Why is sorter an active transformation?
What are the new features of informatica 9.x at the developer level?
what is the Default Source Option For Update Strategy Transformation?
what is the hint? how to use it to reduce the query processing in program?
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
permutations of mapplet
expain about the tune parameters?
Can we override a native sql query within informatica?
What is the sequence generator transformation in informatica?
