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
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
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
explan ur project architecture?
Explain target update override in informatica
Write the advantages of partitioning a session?
what is size of u r database?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is decode in informatica?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is meant by incremental aggregation?
Which are the different editions of informatica powercenter that are available?
Why update strategy and union transformations are active? Explain with examples.
What is informatica? Why do we need it?
What is incremental aggregation?
Enlist few areas or real-time situations where informatica is required.