Question

SQL Server中使用sum来统计count的总数据，为什么会有错误，怎么修改呢

代码：SELECT sum(count([列 0]))
FROM [lunwen].[dbo].[d] where [列 6]like 0 or [列 6]like'' group by [列 0]
GO
错误消息：消息 130，级别 15，状态 1，第 1 行
不能对包含聚合或子查询的表达式执行聚合函数。

Answer 1

拆分成两句
SELECT SUM([mycount]) FROM
(
SELECT count([列 0]) AS mycount
FROM [lunwen].[dbo].[d] where [列 6]like 0 or [列 6]like'' group by [列 0]
)AS A
GO