I am trying to understand the exact difference between my code below,
count(CASE WHEN action = 'accepted' THEN 1 ELSE NULL END) * 1.0 / count(action) as perc
count(CASE WHEN action = 'accepted' THEN 1 ELSE NULL END) * 1.00 / count(action) as perc
When I test both give me same answer, but I have also seen it written both ways so wanted to know to be precise if there was any difference?
0 Replies