select ceiling(2.2222* 100)/100 --保留两位小数,小数位向上取整,输出:2.2300 select floor(2.2222* 100)/100 --保留两位小数,小数位向下取整, 输出:2.2200
sqlserver 保留小数向上向下取
原文:https://www.cnblogs.com/zzgxl/p/13359724.html