adspace


arpan shome


{ City } chennai
< Country > india
* Profession * software engineer
User No # 62585
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 2
Users Marked my Answers as Wrong # 0
Questions / { arpan shome }
Questions Answers Category Views Company eMail




Answers / { arpan shome }

Question { Wipro, 9387 }

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

Select empid,monthyear,sal from empsal
where sal>100000
orderby monthyear;

Is This Answer Correct ?    2 Yes 0 No