dydh je
XSTH1001260002 1950
XSTH1001260002 -1950
XSTH1001260005 567
想要的结果 XSTH1001260005 567
XSTH1001260002 两条记录抵消请大家帮帮写一下
XSTH1001260002 1950
XSTH1001260002 -1950
XSTH1001260005 567
想要的结果 XSTH1001260005 567
XSTH1001260002 两条记录抵消请大家帮帮写一下
select t.dydh
from table t
group by t.dydh
);
select * from
(select dydh,sum(je) je from tb group by dydh)
where je <> 0
刚接触 oracle几天 看不太懂 那个T 是那里来的
select dydh from test group by dydh having sum(je)<>0)
SQL> create table tb(dydh varchar(20), je number)
2 ;表已创建。SQL> INSERT INTO tb
2 SELECT 'XSTH1001260002', 1950 FROM dual union
3 SELECT 'XSTH1001260002', -1950 FROM dual union
4 SELECT 'XSTH1001260005', 567 FROM dual;已创建3行。SQL> select * from tb;DYDH JE
-------------------- ----------
XSTH1001260002 -1950
XSTH1001260002 1950
XSTH1001260005 567SQL> ed
已写入 file afiedt.buf 1 SELECT dydh, SUM(je) AS SUM
2 FROM tb
3 GROUP BY dydh
4* HAVING SUM(je)<>0
SQL> /DYDH SUM
-------------------- ----------
XSTH1001260005 567SQL>