with rollup用法

with rollup用法：
1.没用with rollup:

SELECT name, SUM(signin) as signin_count 
 FROM  employee_tbl 
 GROUP BY name

2.用了with rollup:

SELECT name, SUM(signin) as signin_count 
 FROM  employee_tbl 
 GROUP BY name 
 WITH ROLLUP;

3.如果用了with rollup,想把“NULL”改成其他名字，可用coalesce：

参数说明：如果a为null,则选择b；如果b==null,则选择c；如果a!=null,则选择a；如果a b c 都为null ，则返回为null（没意义）。

SELECT coalesce(name, '总数'), SUM(signin) as signin_count 
FROM  employee_tbl 
GROUP BY name 
WITH ROLLUP;