如何在MySQL中使用WITH ROLLUP?

如下所示

SELECT 
COALESCE(ename,'总计')
,SUM(sal)
FROM 
emp 
GROUP BY 
ename
WITH ROLLUP