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
- 12727 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
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is meant by target load plan?
What do you mean by worklet?
How to create or import flat file definition in to the warehouse designer?
What is the format of informatica objects in a repository?
What is fact table? Explain the different kinds of facts.
What do you understand by a term domain?
In warehouses how many schemas are there?
How does a sorter cache works?
define galaxy repository in informatica
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what is the Default Source Option For Update Strategy Transformation?
Define pmcmd command?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
