MySQL SUM returning unnecessary decimals

Question

I have single record on a table. So on MySQL when

 select myamount from table 1  -- returns amount 420.67

But when i do MySQL as

 select sum(myamount) from table 1 -- returns amount 420.8699951171875

should n't it return same amount 420.67 since I have only one record? and how to get amount 420.67 if SUM used.

Any help is appreciated and yes myamount datatype is float.

Possible duplicate of Using SUM on FLOAT data

Brendan Bullen
– Brendan Bullen

2016-05-11 08:17:55 +00:00
Commented May 11, 2016 at 8:17 — Brendan Bullen
– Brendan Bullen, Commented May 11, 2016 at 8:17

Linkan · Accepted Answer · 2016-05-11 08:25:08Z

1

Float variables are stored in "scientific notation" (the 2,4E+04 format, which is the same as 2,4*10^4). But to make it even worse, it is also stored in binary. When calculating things with numbers stored as float, you may get a bit strange results because of this.

This video by Computerphile describes the problem very nicely.

answered May 11, 2016 at 8:25

Linkan

5791 gold badge7 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL SUM returning unnecessary decimals

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related