SELECT ROUND(CAST (6348.4644 AS decimal (6,2)),1)
其结果是 :6348.50
期望结果:6349.00
如果你想总是四舍五入到上边,那么使用ceiling
函数
SELECT CAST ( ceiling( 6348.4644 ) AS decimal (6,2) )