Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 9271 Views
- Wipro, I also Faced
- E-Mail Answers
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 are 3 tech challenges/ common issues you face?
Write the advantages of partitioning a session?
Enlist some properties of sessions.
How many numbers of sessions can one group in batches?
permutations of mapplet
What is intricate mapping?
Briefly describe lookup transformation?
what is unit testing?tell me proceedure
How do you update the records with or without using update strategy?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the data movement modes in informatica?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
differences between service based and product based?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
