Question

mysql用avg求平均值小数点后面的太多了 怎么限制小数点后2位？

sql语句：select re_fedex,avg(re_number),avg(re_postage),avg(re_cod) from tb_registered where re_fedex='顺丰快递'

这是我输出的值

Answer 1

select re_fedex,avg(TRUNCATE(re_number,2)),avg(re_postage),avg(re_cod) from tb_registered where re_fedex='顺丰快递';
-- 后面的也类似了