SELECT isnull(Name,'小计') AS Name,sum(Value)as Value from test1 group by name with rollup
isnull rollup group by 三个关键字
转载于:https://www.cnblogs.com/tomkillua/archive/2008/10/29/1321869.html
SELECT isnull(Name,'小计') AS Name,sum(Value)as Value from test1 group by name with rollup
转载于:https://www.cnblogs.com/tomkillua/archive/2008/10/29/1321869.html