CODE EXAMPLE FOR SQL

mysql sum cast decimal without round

#convert string to Decimal / Float value and make sum without round problem
SUM(cast(moneyFiled as DECIMAL(10,4))) as moneyFiled # money or float ...