您可以用来
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]
您可以用来
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]
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
