34,594
社区成员
发帖
与我相关
我的任务
分享
SELECT CAST (124131.28*1.57/100 AS DECIMAL(18,4))
SELECT CAST(1948.8611*100/1.57 AS DECIMAL(18,4))
结果为:
(无列名)
1948.8611
(无列名)
124131.2803
SELECT CAST (124131.28*1.57/100 AS DECIMAL(18,4))
SELECT CAST(1948.86*100/1.57 AS DECIMAL(18,4))
SELECT CAST (124131.28*1.57/100 AS DECIMAL(18,4)) ---得到結果:1948.86
SELECT CAST(1948.8611*100/1.57 AS DECIMAL(18,3))---得到的結果:124131.21
---------------------------------------
1948.8611
(1 行受影响)
---------------------------------------
124131.280
(1 行受影响)
是你进位问题,看 结果不解释