SELECT ROUND(15.60,2);#15.6
SELECT ROUND(15.60/3,2);#5.2
SELECT CAST(15.60 / 3 AS decimal(18,2));#5.20
mysql查询结果保留2位小数不够补0
最新推荐文章于 2024-07-28 02:41:29 发布
SELECT ROUND(15.60,2);#15.6
SELECT ROUND(15.60/3,2);#5.2
SELECT CAST(15.60 / 3 AS decimal(18,2));#5.20