一、with rollup

1. 统计函数with rollup（分组统计再统计）

SELECT userName ,sum(login_count) count FROM `t_admin` group by userName with rollup

下面这一行会更清晰：

SELECT coalesce(userName,'总计') name,sum(login_count) count FROM `t_admin` group by userName with rollup