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
- 10599 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
Separate from an archive server and a powerhouse?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Target increases every day even though no new record was inserted
How do you handle two sessions in Informatica
Describe an informatica powercenter?
How to extract sap data using informatica?
What is workflow manager?
is it possible to index the data in cache of lkp transformation ?
What is workflow monitor?
How can we improve session performance in aggregator transformation?
What is Data Caches size?
What is the difference between STOP and ABORT options in Workflow Monitor?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
can anyone explain me about retail domain project in informatica?
expain about the tune parameters?
