***********************
根据你的补充补充回答：
***********************
select a,sum(b) as 记录数,max(c) as c
from 表名
group by a;
---
以上，希望对你有所帮助。
select a,sum(b) as 记录数,c from table group by a,c
select a,sum(b),c from table group by a,b
select a,sum(b),c from 表 group by a,c
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024