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
- 10517 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sameer
Select * from emplyees
Where sal>(select avg ( sal) from emplyees )
No need to write complex queries
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the fact table?
How to extract sap data using informatica?
draw informatica architecture 8.6 ?
What is the difference between router and filter?
Is it possible to create multiple domains on a single Informatica server?
What is a standalone command task?
What are roles and groups and benefits of using them?
How do you handle two sessions in Informatica
Explain the use of aggregator cache file?
What do you mean by filter transformation?
What is the difference between Active and Passive transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the difference between a repository server and a powerhouse?
How would you copy the content of one repository to another repository?
