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
- 10562 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
What is meant by LDAP users?
Have you worked with/created Parameter file
How to do unit testing in informatica?
What are the tasks that source qualifier perform?
Explain how many types of dimensions are available in informatica?
What are the different types of olap? Give an example?
tell me about your project functionality
What is the sql query overwrite in source qualifier in informatica
What is Cognos script editor?
where to store informatica rejected data?
What do think which one is the better joiner or look up?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is an expression transformation in informatica?
If informatica has its scheduler why using third party scheduler?
Differences between connected and unconnected lookup?
