我有一个列valorout
具有这种类型的值:
652.000000
133.000000
163.000000
...
所以,我希望列
valorout
的和按duplicated
分组。查询
select sum(valorout) from trans GROUP BY(duplicated);
错误
Error in query: ERROR: function sum(character) does not exist
LINE 1: select sum(valorout) from trans GROUP BY(duplica...
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
我需要改变什么来解决这个问题?
最佳答案
答案可能是
select sum(valorout::decimal) from trans GROUP BY(duplicated);
您的类型是varchar(50),您需要将其转换为decimal/integer/float才能使SUM生效