方法一: SELECT coalesce(字段1,'总计'), COUNT(统计字段) FROM '表名' GROUP BY 字段1 WITH ROLLUP 方法二: SELECT CASE WHEN 字段1 IS NOT NULL THEN 字段1 ELSE '合计' end 字段1, COUNT(统计字段) FROM `表名` GROUP BY 字段1 WITH ROLLUP