我正在尝试ROUND()或不是所选的值.查询看起来像这样：SELECT b.Series,CASE WHEN Series = 'DMS' THEN ROUND(b.Quantity,0)ELSE ROUND(b.Quantity,2)END AS QuantityFROM bill b我也试过了CASE SeriesWHEN 'DMS' THEN ROUND(b.Quantity,0)ELSE ROUND(b.Quantity,2) END AS Quantity,和IF(b.Series = 'DMS', ROUND(b.Quantity,0), ROUND(b.Quantity,2)) AS Quantity,每次我在最后得到2位小数. 当系列为’DMS’时,数量应该像一个整数...
MySQL版本是5.66.22 当我对存储在varchar中的十进制数使用ROUND函数时,我看到所有.5数字的奇怪行为Select round(0.5) 1Select round('0.5') 0Select round('26.5' + 0.00) 26但Select round(1.5) 2Select round('1.5') 2Select round(0.55, 1) 0.6Select round('0.55', 1) 0.6我检查了Oracle DB(12c)中的ROUND函数,它按预期工作Select round('0.5') from dual 1Select round(0.5) from dual 1有谁知道如何解释？ 描述的mysql rou...
MySQL中ROUND和TRUNCATE的区别1、ROUND可以进行四舍五入，按照对应的位数 2、TRUNCATE直接按照位数截取，不四舍五入 实例： SELECT ROUND(RAND(),4),TRUNCATE(RAND(),4);再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow