我正在使用SQL Server 2005和VS 2008。我有一个如下所示的查询:
SELECT Month
, SUM(Man) AS Man
, SUM(Sal) AS Sal
, SUM(Man + Sal) AS Total
FROM (
SELECT DATENAME(MONTH, DOB) AS Month
, CASE WHEN TypeOfPost = 'Manager' THEN 1 ELSE 0 END AS Man
, CASE WHEN TypeOfPost = 'Sales' THEN 1 ELSE 0 END AS Sal
FROM tableName
) g
GROUP BY
Month
产生如下输出
Output--
-------------------------------------
Month Man Sal Total
-------- ----- ------ ---------
January 1 1 2
June 1 NULL 1
November 1 1 2
现在我想计算“总计”列的总和,请帮帮我。
Expected Output--
-------------------------------------
Month Man Sal Total
-------- ----- ------ -------
January 1 1 2
June 1 NULL 1
November 1 1 2
-------------------------------------
Total 5
-------------------------------------