Question

db2 求和时报错。select sum(a) from (select cast(TRF_TRANAMT as decimal(16,2)) a from pb_tranflow);

加了别名还是不行的。。。。TRF_TRANAMT是varchar类型的。但是里面全是小数数值。 报错为SQL0420N 在函数 "DECIMAL" 的字符串自变量中找到无效字符。 SQLSTATE=22018

Answer 1

是否有空字符串，应该在转化之前作特殊处理
SQL Server语法:
Case TRF_TRANAMT When '' Then Cast(Null as Decimal(16,2)) Else Cast(TRF_TRANAMT as Decimal(16,2))

Answer 2

select sum(a) from (select cast(TRF_TRANAMT as decimal(16,2)) a from pb_tranflow) as cccc ;
结果集缺少别名！

Answer 3

是不是长度不够啊，再往大改改，改成20看还出错么？