可用函数cast转换varchar为integer再统计
SELECT col1, SUM(cast(col2 AS integer))
FROM test
GROUP BY col1
你的“两张表中相同条件下”可以解释清楚些吗?最好罗列要显示的字段也要统计的字段,并且说明关键字
SELECT col1, SUM(cast(col2 AS integer))
FROM test
GROUP BY col1
你的“两张表中相同条件下”可以解释清楚些吗?最好罗列要显示的字段也要统计的字段,并且说明关键字
这样的语句报错问题出在何处?
select convert(varchar(10),sum(cast(col as int(5)))) from
(select col from table1 where item1 like‘12%' and item2='19'
union all select col from table2 where item1 like‘12%' and item2='19')
运行该语句是总是报"第 4 行: ')' 附近有语法错误。"的信息,请问问题出在什么地方?
select convert(varchar(10),sum(cast(col as int(5)))) from
(select col from table1 where item1 like'12%' and item2='19'
union all select col from table2 where item1 like'12%' and item2='19') as temptable