oracle 正负抵消记录?该怎么解决
oracle 正负抵消记录?
dydh je
XSTH1001260002 1950
XSTH1001260002 -1950
XSTH1001260005 567
想要的结果 XSTH1001260005 567
XSTH1001260002 两条记录抵消
请大家帮帮写一下
------解决方案--------------------
select * from table where dydh not in(
select t.dydh
from table t
group by t.dydh
);
------解决方案--------------------
针对你的数据可以这样……
dydh je
XSTH1001260002 1950
XSTH1001260002 -1950
XSTH1001260005 567
想要的结果 XSTH1001260005 567
XSTH1001260002 两条记录抵消
请大家帮帮写一下
------解决方案--------------------
select * from table where dydh not in(
select t.dydh
from table t
group by t.dydh
);
------解决方案--------------------
针对你的数据可以这样……
- SQL code
select * from (select dydh,sum(je) je from tb group by dydh) where je <> 0
------解决方案--------------------
select * from test where dydh in (
select dydh from test group by dydh having sum(je)<>0)