mysql 简单分组统计 如何实现？
数据结构
PCode PCount
5________1
6________0
7________0
5________1
6________2
7________0
5________0
6________2
7________0
6________2
8________1
结果
PCode PCount
5________2
6________6
7________0
8________1
——解决方案——————–
- SQL code
select PCode, PCount=sum(PCount) from tb group by PCount;
------解决方案--------------------
- SQL code
--> 测试数据：[test] if object_id('[test]') is not null drop table [test] create table [test]([PCode] int,[PCount] int) insert [test] select 5,1 union all select 6,0 union all select 7,0 union all select 5,1 union all select 6,2 union all select 7,0 union all select 5,0 union all select 6,2 union all select 7,0 union all select 6,2 union all select 8,1 select [PCode],SUM([PCount]) as [PCount] from test group by [PCode] /* PCode PCount 5 2 6 6 7 0 8 1 */欢迎大家阅读《MySql 简单分组统计 怎么实现》,跪求各位点评，by 搞代码
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：MySql 简单分组统计 怎么实现 
