a字段相同的,把b字段根据是否大于0小于0相加
table tta b
1 111
1 222
1 -111
1-333
2 111
想把a相同(group)的 b中大于0,小于0的分别sum select a,sum(b) from ttt where b>0 group by a
select a,sum(b) from ttt where b<0 group by a SELECT GROUP,
SUM(CASE WHEN B > 0 THEN B ELSE 0 END),
SUM(CASE WHEN B < 0 THEN B ELSE 0 END)
FROM TT
WHERE
GROUP BY GROUP
页:
[1]