133.9661836800000000
190.7299411200000000
132.5726380800000000
143.9997120000000000
213.4911859200000000
75.5301715200000000
438.5952518400000000
我需要保留小数点后两位的数据,并且让它四舍五入...求高手指点,谢谢
5 个解决方案
#1
cast(col as dec(18,2))
#2
cast (xxx as decimal(15,2))
#3
select cast(ROUND(字段,2) as numeric(18,2)) from tb
#4
select cast(col as dec(18,2)) from tb
#5
select cast(col as dec(18,2)) from tb
#1
cast(col as dec(18,2))
#2
cast (xxx as decimal(15,2))
#3
select cast(ROUND(字段,2) as numeric(18,2)) from tb
#4
select cast(col as dec(18,2)) from tb
#5
select cast(col as dec(18,2)) from tb