Create table #T([Item] nvarchar(22),[Color] nvarchar(22),[Quantity] int)
Insert #T
select N'桌子',N'白色',1 union all
select N'桌子',N'红色',2 union all
select N'椅子',N'白色',3 union all
select N'椅子',N'红色',4
Go
SELECT
CASE
WHEN GROUPING(Item) = 1
THEN '合计'
ELSE
Item
END Item,
CASE
WHEN GROUPING(Color) = 1
THEN Item + '小计'
ELSE
Color
END Color,
SUM(Quantity) AS Quantity
FROM
#T
GROUP BY
Item,
Color WITH ROLLUP;