isnull rollup group by 三个关键字

SELECT isnull(Name,'小计') AS Name,sum(Value)as Value from test1 group by name with rollup