- 常用取整函数:
- round
- ceil
- floor
round: 四舍五入
select round(3.14); select round(3.54);ceil
ceil: 向上取整
select ceil(3.14); select ceil(3.54);floor
floor: 向下取整
select floor(3.14); select floor(3.54);

round: 四舍五入
select round(3.14); select round(3.54);ceil
ceil: 向上取整
select ceil(3.14); select ceil(3.54);floor
floor: 向下取整
select floor(3.14); select floor(3.54);