27,579
社区成员
发帖
与我相关
我的任务
分享
declare @T table([name] nvarchar(6),[ge] int)
Insert @T
select N'abc',40 union all
select N'abc123',123 union all
select N'Add',4379 union all
select N'bbb',777 union all
select N'd',123
Select
[name]=case when grouping([name])=1 then '合計' when grouping([ge])=1 then '' else [name] end,
[ge]=isnull(rtrim([ge]),''),
case when grouping([ge])=1 then rtrim(sum([ge])) else '' end 小记
from @T group by [name],[ge] with rollup
(5 個資料列受到影響)
name ge 小记
------ ------------ ------------
abc 40
40
abc123 123
123
Add 4379
4379
bbb 777
777
d 123
123
合計 5442
(11 個資料列受到影響)
declare @T table([name] nvarchar(6),[ge] int)
Insert @T
select N'abc',40 union all
select N'abc123',123 union all
select N'Add',4379 union all
select N'bbb',777 union all
select N'd',123
Select
[name]=case when grouping([name])=1 then '合計' when grouping([ge])=1 then '' else [name] end,
[ge]=isnull(rtrim([ge]),''),
sum([ge]) 小记
from @T group by [name],[ge] with rollup
(5 個資料列受到影響)
name ge 小记
------ ------------ -----------
abc 40 40
40
abc123 123 123
123
Add 4379 4379
4379
bbb 777 777
777
d 123 123
123
合計 5442
(11 個資料列受到影響)