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
- 12702 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ram
SELECT * FROM emp e WHERE sal > (SELECT AVG(sal) FROM emp m
WHERE e.deptno = m.deptno GROUP BY deptno) ORDER BY deptno
gives u salary greater than the average salary of their
departments...
| Is This Answer Correct ? | 22 Yes | 4 No |
Post New Answer View All Answers
How do we call shell scripts from informatica?
What is deployment group?
Under what condition selecting sorted input in aggregator may fail the session?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is Session and Batches?
what is size of u r database?
What is an aggregator transformation?
What are the different types of repositories created using informatica?
Explain the types of lookup transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Informatica settings are available in which file?
What is native users?
What do you mean by enterprise data warehousing?
What is the function of aggregator transformation?
can u any challenge your project?
