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
- 12433 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
Clarify the aggregator change?
What is an expression transformation in informatica?
is it possible to index the data in cache of lkp transformation ?
What does cheating measurement mean?
How big was your fact table
What is event and what are the tasks related to it?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is dimensional table?
Does an informatica transformation support only aggregate expressions?
Explain why we use partitioning the session in informatica?
What is mapplet in informatica?
What is sq transformation?
server hot-ws270 is connect to Repository B. What does it mean?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
