原表table 列1 列2 列3
aaa zzzz 1
aaa zzzz 2
aaa bbb 1
bbb zzzz 3
bbb zzzz 2
bbb bbb 1
bbb bbb 3
bbb ccd 2查询如果如下: 列1 列2 列3
aaa zzzz 3
aaa bbb 1
bbb zzzz 5
bbb bbb 4
bbb ccd 2 按列1和列2进行分组汇总
aaa zzzz 1
aaa zzzz 2
aaa bbb 1
bbb zzzz 3
bbb zzzz 2
bbb bbb 1
bbb bbb 3
bbb ccd 2查询如果如下: 列1 列2 列3
aaa zzzz 3
aaa bbb 1
bbb zzzz 5
bbb bbb 4
bbb ccd 2 按列1和列2进行分组汇总
FROM tb
GROUP BY col1,col2;
select col1,col2,col3=sum(col3)
from table
group by col1,col2
insert @tb
select 'aaa', 'zzzz', 1 union all
select 'aaa', 'zzzz', 2 union all
select 'aaa', 'bbb', 1 union all
select 'bbb', 'zzzz', 3 union all
select 'bbb', 'zzzz', 2 union all
select 'bbb', 'bbb', 1 union all
select 'bbb', 'bbb', 3 union all
select 'bbb', 'ccd', 2 select 列1,列2,sum(列3) '分组汇总' from @tb
group by 列1,列2
列1 列2 分组汇总
----- ----- -----------
aaa bbb 1
bbb bbb 4
bbb ccd 2
aaa zzzz 3
bbb zzzz 5(所影响的行数为 5 行)