Techiio-author
Started by Lidig TinilaloSep 18, 2021

Open
multiplying by 1.0 or 1.00 when dividing

0 VIEWES 0 LIKES 0 DISLIKES SHARE
0 LIKES 0 DISLIKES 0 VIEWES SHARE

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

You must be Logged in to reply
Techiio-logo

Techiio is on the journey to build an ocean of technical knowledge, scouring the emerging stars in process and proffering them to the corporate world.

Follow us on:

Subscribe to get latest updates

You can unsubscribe anytime from getting updates from us
Developed and maintained by Wikiance
Developed and maintained by Wikiance