with rollup

select coalesce(t.name,'总'),sum(t.v) from (select '小丽' as name,1 as v UNION ALL select '小丽' as name,2 as v ) t group by t.name with ROLLUP

　　

with ROLLUP  结合 coalesce() 自动汇总.