数据: a1 a2 0 12 1 12 0 30 1 31 select sum(a2) from aaaa t group by a1 结果: sum(a2) 42 43
zsfww1205(努力学习oracle),谢谢!
select sum(i) from tablename group by int xxxx
select sum(值) from table group by int类型的字段 不对吧, 要的是 >> 要求:求出此字段相同类型的值的和 tables:test (....,intTest int,...) 只能挑选出有相同值的,只有一个值一样的,就不要了啊。呵呵。select sum(intTest),count(*) From test group by intTest having count(*) >1才是需要的吧?
a1 a2
0 12
1 12
0 30
1 31
select sum(a2) from aaaa t group by a1
结果:
sum(a2)
42
43
不对吧,
要的是
>> 要求:求出此字段相同类型的值的和
tables:test
(....,intTest int,...)
只能挑选出有相同值的,只有一个值一样的,就不要了啊。呵呵。select sum(intTest),count(*) From test group by intTest having count(*) >1才是需要的吧?