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
- 12730 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
Can you use flat files in Mapplets.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What is a shortcut and copy in Informatica and how two are different with each other?
What are the different components of powercenter?
What are the mapping parameters and mapping variables?
how many types of dimensions are available in informatica?
Describe data concatenation?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is the difference between source qualifier transformations source filter to filter transformation?
Clarify the aggregator change?
Explain pushdown optimization and types in informatica
How do you convert single row from source into three rows into target?
How can we use mapping variables in informatica? Where do we use them?
Which transformation is needed while using the Cobol sources as source definitions?
explain abt ur project architecture?
