select ceiling(2.2222* 100)/100 --保留两位小数,小数位向上取整,输出:2.2300 select floor(2.2222* 100)/100 --保留两位小数,小数位向下取整, 输出:2.2200
2023-12-25 13:41:52
select ceiling(2.2222* 100)/100 --保留两位小数,小数位向上取整,输出:2.2300 select floor(2.2222* 100)/100 --保留两位小数,小数位向下取整, 输出:2.2200