sql-server - 与 SQL Server RollUP 求和 - 但只是最后的总结？

Question

我有这个查询:

DECLARE @t TABLE(NAME NVARCHAR(MAX),datee date,val money)

insert INTO @t SELECT 'a','2012-01-02',100
insert INTO @t SELECT 'a','2012-01-02',100
insert INTO @t SELECT 'a','2012-01-03',100
insert INTO @t SELECT 'a','2012-01-05',100
insert INTO @t SELECT 'b','2012-01-06',200
insert INTO @t SELECT 'b','2012-01-07',200
insert INTO @t SELECT 'd','2012-01-07',400
insert INTO @t SELECT 'e','2012-01-09',500
insert INTO @t SELECT 'f','2012-01-12',600

SELECT  Name,datee,SUM (val) 
from @t GROUP BY NAME ,datee 

目前的结果是:

但我需要在末尾添加 sum 。所以我尝试使用汇总:

 SELECT  Name,datee,SUM (val) 
    from @t GROUP BY NAME ,datee  with ROLLUP

但我只需要最后总和行。我不需要报告内 总和

那么怎样才能得到想要的结果呢？

(我无法更改 group by 子句，因为其他人也需要它，我只想在有/没有汇总的情况下在末尾添加总和)。

sql online is here

Answer 1

可以使用GROUPING SETS，试试这个:

SELECT  Name,datee,SUM (val) 
FROM    @t 
GROUP BY 
        GROUPING SETS((NAME ,datee), ())

SQL Fiddle