这样为什么不能不四舍五入?
SELECT ROUND (15375/100, 0) as a
为什么不得到154
[解决办法]
SELECT ROUND (15375.0/100, 0) as a
[解决办法]
SELECT ROUND (15375*0.01, 0) as a
[解决办法]
SELECT cast(ROUND (15375*1.0/100, 0) as int) as a
[解决办法]
SELECT cast(ROUND (15375.0/100, 0) as int)as a
[解决办法]
SELECT cast(ROUND (15375*1.0/100, 0) as int) as a
