#TRUNCATE(x,d):函数返回被舍去至小数点后d位的数字x。若d的值为0,则结果不带有小数点或不带有小数部分。若d设为负数,则截去(归零)x小数点左起第d位开始后面所有低位的值。
select
sum(salay),
avg(salay),
TRUNCATE(avg(salay),2)
from sys_user;
结果:
sum(salay) avg(salay) TRUNCATE(avg(salay),2)
45000 7500.0000 7500.00
#round(x,d),四舍五入。round(x),其实就是round(x,0),也就是默认d为0
select
sum(salay),
avg(salay),
ROUND(avg(salay),2)
from sys_user;
结果:
sum(salay) avg(salay) ROUND(avg(salay),2)
45000 7500.0000 7500.00
#FORMAT(x,d),四舍五入,保留d位小数,返回string类型
select
sum(salay),
avg(salay),
format(avg(salay),3)
from sys_user;
结果:
sum(salay) avg(salay) format(avg(salay),3)
45000 7500.0000 7,500.000