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
- 12696 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / lokesh y g
select e.no,e.name,e.salary from emp e where salary >
(select avg(salary)as salary from emp e1 where e.no=e1.no
group by no)
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is domain and gateway node?
Explain the difference between a data warehouse and a data mart?
How to generate sequence numbers?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Briefly define a session task?
When do you use sql override in a lookup transformation?
How to differentiate between the active and passive transformations?
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 need of etl tools?
How to extract sap data using informatica?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain the different kinds of facts.
What is target designer and target load order?
What are the different components of powercenter?
Is there any way to read the ms excel datas directly into informatica?
