计算组内的每个条件

计算组内的每个条件

您可以用来

count

对每个行进行计数

[GroupId]

并

sum

计算每个属性。

select [GroupId]     , count([GroupId]) as [TotalRows]     , sum([IsGreen]) as [TotalGreen]     , sum([IsRound]) as [TotalRound]     , sum([IsLoud]) as [TotalLoud]from [TestData]group by [GroupId]