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
- 12717 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 informatica worklet?
What is the difference between a repository server and a powerhouse?
What is aggregator transformation in informatica?
When do you use sql override in a lookup transformation?
What are the popular informatica products?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to update source definition?
What is a filter transformation?
Under which circumstances, informatica server creates reject files?
What is the difference between Active and Passive transformation?
Explain sessions?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Is there any target staging area in informatica not staging area
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the steps involved in the migration from older version to newer version of Informatica Server?
