Thread
:
Wrong sum with float and group by
View Single Post
#
1
(
permalink
)
02-28-2008, 08:30 AM
_mario.lat
Posts: n/a
Wrong sum with float and group by
Hallo,
I have a problem with a query like that:
SEMECT 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.lat