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
- 12506 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
EXL informatica Questions
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Is it possible to revert a global repository to local one and why?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are the performance considerations when working with aggregator transformation?
What is the difference between a repository server and a powerhouse?
What are the data movement modes in informatica?
explain about unit testing? in real time?
wf dont have integration severances how you can run?
Explain pushdown optimization and types in informatica
what is the complex transformation you used in informatica
explan ur project architecture?
What is rank index in rank transformation?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Can we create two repositories on same database instance in oracle?
