请帮忙看下这段代码里 哪里错了?
SELECT banci AS p1, count(id) AS p2, sum(cint(p4)) AS p3
FROM t_a_onlineDetail
GROUP BY banci;
[解决办法]
cint(p4)改为CAST(p4 as int)
发布时间: 2012-02-03 22:02:47 作者: rapoo
请帮忙看下这段代码里 哪里错了?
SELECT banci AS p1, count(id) AS p2, sum(cint(p4)) AS p3
FROM t_a_onlineDetail
GROUP BY banci;
[解决办法]
cint(p4)改为CAST(p4 as int)