表tb1中
col1 col2 col3
A1 1 20
A1 1 30
A1 2 15
A1 2 20
A2 1 15
A2 1 40我想要的结果是根据col1和col2的条件总计出col3需要的结果如下:
col1 col2 col3
A1 1 50
A1 2 35
A2 1 55请大家教一下小弟弟,谢谢
col1 col2 col3
A1 1 20
A1 1 30
A1 2 15
A1 2 20
A2 1 15
A2 1 40我想要的结果是根据col1和col2的条件总计出col3需要的结果如下:
col1 col2 col3
A1 1 50
A1 2 35
A2 1 55请大家教一下小弟弟,谢谢
go
create table tb1(col1 varchar(5), col2 int, col3 int)
insert tb1 select 'A1', 1 , 20
insert tb1 select 'A1', 1 , 30
insert tb1 select 'A1', 2 , 15
insert tb1 select 'A1', 2 , 20
insert tb1 select 'A2', 1 , 15
insert tb1 select 'A2', 1 , 40
select col1,col2, sum(col3)col3 from tb1 group by col1,col2
/*col1 col2 col3
----- ----------- -----------
A1 1 50
A2 1 55
A1 2 35*/
select col1,col2,sum(col3) col3 from tb group by col1,col2
insert into tb values('A1' , 1 , 20 )
insert into tb values('A1' , 1 , 30 )
insert into tb values('A1' , 2 , 15 )
insert into tb values('A1' , 2 , 20 )
insert into tb values('A2' , 1 , 15 )
insert into tb values('A2' , 1 , 40 )
goselect col1,col2,sum(col3) col3 from tb group by col1 , col2 drop table tb/*
col1 col2 col3
---------- ----------- -----------
A1 1 50
A1 2 35
A2 1 55(所影响的行数为 3 行)
*/