提个简单问题．

要查询中相加．
如表 ta：　A B
　　　 １　　３
　　　 2　　 ６
　　　 ３　　８
我想查出的一结果是B这列的数字求和．
select A,B,sum(B) as B总计
from ta
group by a

是不是这样写？

SQL code

select sum(B) from ta

SQL code

select a.*,b.[sumB]
from ta a
join (select sum(b) as [sumB] from ta) b on 1=1

SQL code

if object_id('[ta]') is not null drop table [ta]
go
create table [ta]([A] int,[B] int)
insert [ta]
select 1,3 union all
select 2,6 union all
select 3,8
go

select a.*,b.[sumB]
from ta a
join (select sum(b) as [sumB] from ta) b on 1=1

/**
A           B           sumB
----------- ----------- -----------
1           3           17
2           6           17
3           8           17

(3 行受影响)
**/

SQL code

select sum(B) from ta--无条件求全表中B字段的总和

select A,sum(B) from ta group by a  --分组求和