tb_test
col1 col2 col3 col4 col5
A s a1 sz 5
A s a1 sz 5
A s a1 sh 5
A s a1 sh 5
A s a1 sh 5
B z a2 sz 5
B z a2 sz 5
B z a2 bj 5
B z a2 bj 5
B z a2 bj 5
B z a2 bj 5
得到如下形式 :
tb_test
col1 col2 col3 col4 col5
A s a1 sz 10
A s a1 sh 15
B z a2 sz 10
B z a2 bj 20
col1 col2 col3 col4 col5
A s a1 sz 5
A s a1 sz 5
A s a1 sh 5
A s a1 sh 5
A s a1 sh 5
B z a2 sz 5
B z a2 sz 5
B z a2 bj 5
B z a2 bj 5
B z a2 bj 5
B z a2 bj 5
得到如下形式 :
tb_test
col1 col2 col3 col4 col5
A s a1 sz 10
A s a1 sh 15
B z a2 sz 10
B z a2 bj 20
from [Table]
group by col1,col2,col3,col4
col1,col2,col3,col4,sum(col5) as col5
from
tb
group by
col1,col2,col3,col4
insert into tb_test values('A' ,'s', 'a1', 'sz', 5)
insert into tb_test values('A' ,'s', 'a1', 'sz', 5)
insert into tb_test values('A' ,'s', 'a1', 'sh', 5)
insert into tb_test values('A' ,'s', 'a1', 'sh', 5)
insert into tb_test values('A' ,'s', 'a1', 'sh', 5)
insert into tb_test values('B' ,'z', 'a2', 'sz', 5)
insert into tb_test values('B' ,'z', 'a2', 'sz', 5)
insert into tb_test values('B' ,'z', 'a2', 'bj', 5)
insert into tb_test values('B' ,'z', 'a2', 'bj', 5)
insert into tb_test values('B' ,'z', 'a2', 'bj', 5)
insert into tb_test values('B' ,'z', 'a2', 'bj', 5)
goselect col1 , col2 ,col3 ,col4 ,sum(col5) col5 from tb_test group by col1 , col2 ,col3 ,col4drop table tb_test/*
col1 col2 col3 col4 col5
---------- ---------- ---------- ---------- -----------
A s a1 sh 15
A s a1 sz 10
B z a2 bj 20
B z a2 sz 10(所影响的行数为 4 行)*/