following scenario empsal table i want who exist one lakshs
sal above monthwise?
`
empsal
empid monthyear sal
1 jan2008 1000
2 march2009 50000
3 april2009 4000
4 feb2009 100000
5 jul2009 600000
6 dec 2008 90000
Answer Posted / sateesh
select * from empsal GROUPBY ‘monthyear’
HAVING sal>=100000.
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is workflow monitor?
Define sessions in informatica etl?
Which is the t/r that builts only single cache memory?
how to load rows into fact table in data warehouse
What is the session task and command task?
What is the difference between source qualifier transformations source filter to filter transformation?
What is an unconnected transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What are the new features of informatica 9.x at the developer level?
Why sorter is an active transformation?
How many dimensions are there in informatica?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is informatica?
What is native users?
can we override a native sql query within informatica? How do we do it?