_mario.lat wrote:

> On Tue, 07 Nov 2006 06:40:48 -0500, Jerry Stuckle wrote:
>
>> _mario.lat wrote:
>>> Hallo,
>>> I have a problem with a query like that:
>>> SELECT SUM(price) as total FROM product GROUP BY type
>>>
>>> price is float or double.
>>> total is not the exact sum.
>>> How can I do?
>>> Thank you in advance,
>>> Mario.
>>
>> Mario,
>>
>> What do you mean "total is not the exact sum"?
>
> Thankyou to all for answering (and reading) me.
>
> If you have a table with the value:
> type,price
> a,1.2
> b,0.1
> c,3.4
>
> real SUM (or real total) is 1.2+0.1+3.4 = 4.6


4.7 actually.


> the query
> SELECT SUM(price) as total FROM product GROUP BY type
> give me: total 4.5 for example.


I can't replicate that. I suspect you aren't telling us the full story.



mysql> SELECT * FROM math;
+----+-------+------+
| id | price | type |
+----+-------+------+
| 1 | 1.2 | 1 |
| 2 | 0.1 | 1 |
| 3 | 3.4 | 1 |
+----+-------+------+
3 rows in set (0.00 sec)

mysql> SELECT SUM(price) AS total FROM math GROUP BY type;
+------------------+
| total |
+------------------+
| 4.70000014454126 |
+------------------+
1 row in set (0.00 sec)

mysql> SELECT FORMAT(SUM(price),1) AS total FROM math GROUP BY type;
+-------+
| total |
+-------+
| 4.7 |
+-------+
1 row in set (0.00 sec)




--
Brian Wakem
Email: http://homepage.ntlworld.com/b.wakem/myemail.png