select ceil(2.44),round(2.44),floor(2.44),avg(2.44);
3 2 2 2.44
ceil为向上取整,round为四舍五入取整(四舍六入五成双),floor为向下取整,avg带小数点取整
select ceil(2.44),round(2.44),floor(2.44),avg(2.44);
3 2 2 2.44
ceil为向上取整,round为四舍五入取整(四舍六入五成双),floor为向下取整,avg带小数点取整