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
- 12700 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
Which are the different editions of informatica powercenter that are available?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What will be the approach?
Briefly describe lookup transformation?
Why is sorter an active transformation?
What do you mean by worklet?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are the different types of repositories created using informatica?
Performance tuning( what you did in performance tuning)
r u done any partitions in ur project?
Why update strategy and union transformations are active? Explain with examples.
How can we remove the duplicates from flat file source?
Can we create two repositories on same database instance in oracle?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
what is song in infrmatica...?
