select num,name,sum(shuliang) as tong from biao where num='444444' group by name,num
执行语句报错 sum or average aggregate 运算不能以 char 数据类型作为参数
我数据库中shuliang为char型的,不能修改,怎么才能使shuliang变为数值型
...全文
433打赏收藏
急,数据库数据类型的转换
select num,name,sum(shuliang) as tong from biao where num='444444' group by name,num 执行语句报错 sum or average aggregate 运算不能以 char 数据类型作为参数 我数据库中shuliang为char型的,不能修改,怎么才能使shuliang变为数值型