如下所示
SELECT COALESCE(ename,‘总计‘) ,SUM(sal) FROM emp GROUP BY ename WITH ROLLUP
如何在MySQL中使用WITH ROLLUP?
原文:https://www.cnblogs.com/renguanyu/p/12230217.html