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
- 12919 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / manoj
SELECT *FROM EMP WHERE SAL>(SELECT AVG(SAL) FROM EMP WHERE
DEPTNO=10);
this is correct answer. all the above answer are wrong except last one. Because in single row sub query we can't use group by clause. In all above queries they were used '>' simbol. So this is single row sub query matching operator.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
To import the flat file definition into the designer where should the flat file be placed?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How can you increase the performance in joiner transformation?
What is sorter transformation?
In informatica workflow manager, how many repositories can be created?
Is it possible to define a single node as a Gateway node as well as worker node?
Briefly define reusable transformation?
How can we use mapping variables in informatica? Where do we use them?
How will the document be delivered to me?
What is the commit type if you have a transaction control transformation in the mapping?
What is a joiner transformation?
Could you explain what is enterprise data warehouse?
What is fact table? Explain the different kinds of facts.
How to differentiate between the active and passive transformations?
