前辈请留步耽误你一小会时间

[wujilin]

为什么结果分在两张表中 怎么使结果汇总到一个表
Uid A B C
123 1 2 3
2EE 4 5 6
SSO 5 5 5

我想得到

Uid A B C
123 1 2 3
2EE 4 5 6
SSO 5 5 5
10 12 14

我的语句
select *
from tablename
order by Uid
compute sum(10) sum(12) sum(14)
可结果出现在两个表中

怎么觉得这个问题

[wzy_love_sly]

select uid,a,b,c from 表
union all
select '',sum(a),sum(b),sum(c) from 表

[CN_SQL]

select
	isnull(uid,'') as uid,
	sum(a) as a,
	sum(b) as b,
	sum(c) as c
from tablename 
group by uid 
with rollup
order by case when uid is null then 1 else 0 end 

[htl258_Tony]

已解决，楼主可以结贴了。

[MJunnnn]

select * from tablename
select sum(A),sum(B),sum(C) from tablename

[ai_li7758521]

if object_id('tablename') is not null
drop table tablename

create table tablename(Uid nvarchar(20),A   int,B   int,C   int)

insert into tablename
select '123',1,2,3 union all
select '2EE',4,5,6 union all
select 'SSO',5,5,5 

(select * 
from tablename)
union all 
select '汇总',sum(A),sum(B),sum(C) 
from tablename

[ai_li7758521]

Uid                  A           B           C
-------------------- ----------- ----------- -----------
123                  1           2           3
2EE                  4           5           6
SSO                  5           5           5
汇总                    10          12          14

(4 行受影响)