mysql使用sql常用问题汇总

Mysql 解决 sum求和有多位小数

SELECT cast(COALESCE(SUM(zbjffz),0) AS DECIMAL(10,2)) AS zbjffz from t_mbo_hbzbgl where zblx='0' and sjzbbh=#{zbzj}