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
- 9108 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 the settings that you use to configure the joiner transformation?
Write the program through which the records can be updated?
What is the meaning of up gradation of repository?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is persistent lookup cache?
Explain sessions?
What is a router transformation?
scenario where i can use only concurrent execution of workflow.
What is standalone command task?
Why union transformation is an active transformation?
What is meant by target load plan?
what is the difference between informatica6.1 and infomatica7.1
What is a node in Informatica?
Reusable transformation and shortcut differences
What are the main features of Oracle 8i with context to datawarehouse?
