COALESCE(col3,0) AS col3 如果col3查出是null则返回0
Round(col3/10000,3) as col2 col3除10000后取小数点后三位,
注:10000和3可以变根据需求写
select COALESCE( Round(sum(col3)/10000,3),0) from biao;
COALESCE(col3,0) AS col3 如果col3查出是null则返回0
Round(col3/10000,3) as col2 col3除10000后取小数点后三位,
注:10000和3可以变根据需求写
select COALESCE( Round(sum(col3)/10000,3),0) from biao;