Question

sql分组求和查询语句

如表:test
s1 s2
-- ---
a 100
a 0
b 0
b 0
c 1
c 0

要求:分组查询s1，并且s2的和等于零
请把语句写的详细，谢谢

Answer 1

select s1,sum(s2)
from test
group by s1
having sum(s2) = 0