im trying to divide 2 columns but when i divide it equals 0. However if i add, subtract or multiple it works fine...
select #all.playerid, #won.wongames, #all.allgame, #won.wongames/#all.allgame as percentage
from #all
left join #won
on #all.playerid = #won.playerid
Thanks in advance.
MehulIm thinking it might be that it does not allow decimals... is there a way to overcome this??
Thanks
No comments:
Post a Comment