select id,sum(n) from table group by id,n with cube
Insert into test select uid,sum(n) from test group by uid
其中test是表名,uid就是你的表中的id
select * from [tablename] union all select id,sum(n) from [tablename] group by id order by id,n
select id,n,'' as a from Tabtestunion select id,convert(char(50),sum(n)) as n,'Total' as a from Tabtest group by id order by id,n,a结果:(我发现ID :1,N :20的记录只有一个,你自己再想办法吧,该吃饭了) id n a ----------- ----------- ----- 1 10 1 20 1 50 Total 2 40 2 40 Total 3 20 3 30 3 50 Total
select id,n,'' as a from Tabtestunion select id,convert(char(50),sum(n)) as n,'Total' as a from Tabtest group by id order by id,n,a结果:(我发现ID :1,N :20的记录只有一个,你自己再想办法吧,该吃饭了) id n a ----------- ----------- ----- 1 10 1 20 1 50 Total 2 40 2 40 Total 3 20 3 30 3 50 Total
from table
group by id,n
with cube
union all
select id,sum(n) from [tablename] group by id
order by id,n
group by id
order by id,n,a结果:(我发现ID :1,N :20的记录只有一个,你自己再想办法吧,该吃饭了)
id n a
----------- ----------- -----
1 10
1 20
1 50 Total
2 40
2 40 Total
3 20
3 30
3 50 Total
group by id
order by id,n,a结果:(我发现ID :1,N :20的记录只有一个,你自己再想办法吧,该吃饭了)
id n a
----------- ----------- -----
1 10
1 20
1 50 Total
2 40
2 40 Total
3 20
3 30
3 50 Total