MySql 聚合统计 在每个分类下面新增合计（WITH ROLLUP ）

MySQL提供了 group by with rollup 函数进行group by 字段的汇总

但是order by 互斥的不能同时用

---

一、实列

1、原数据结构

2、实现的效果

3、语法

SELECT 
	ifnull(a.xy_name,'合计') yx, if(a.xy_name is not  null and  a.zy_name is null ,'合计',a.zy_name) zy,count(1) as sl 
from zy_onestop_db.vi_college_major_statistics a 
WHERE a.zspc = '1435503837543669760' 
GROUP BY a.xy_name,a.zy_name
WITH ROLLUP