Question

sql查询想在同一类数据下面增加一行总计？

比如这样子。sql语句如下:
SELECT sc.company,sum(e.expenditure_money) as expenditure_money,se.`name`,st.expenditure_type,e.create_time
FROM finance_expenditure e
LEFT JOIN system_company sc ON sc.id=e.company_id
LEFT JOIN system_expenditure_type st ON st.id=e.expenditure_type_id
LEFT JOIN system_employee se ON se.id=e.employee_id
GROUP BY sc.company,se.`name`,st.expenditure_type
union all
select '合计' as company,sum(e.expenditure_money),null as name,null as expenditure_type,null as create_time
FROM finance_expenditure e
LEFT JOIN system_company sc ON sc.id=e.company_id
GROUP BY sc.company
ORDER BY company
该怎么修改





Answer 1

group by rollup（company）
默认汇总行是空置，可以在select部分用空值判断或者用grouping函数修改汇总名称

Answer 2

再写个unionall呗。