This content has been marked as final. Show 4 replies
Once check the data type of that column may be it is considering this as character.
If help plz mark.
Thanx for the feedback. i checked, its number only..!!
Check ,it might have null values in it..Use IFNULL(Exp,0)..if you add null values then the result will be always empty..
Thank you, it is working.