1、备份
CREATE TABLE TDEL04_BAK AS
SELECT * FROM TDEL04 A
WHERE A.ROWID != (SELECT MIN(ROWID) FROM TDEL04 B WHERE A.FCONNO = B.FCONNO)
AND A.FCONNO IN (SELECT FCONNO FROM TDEL02 WHERE FMEMO='M0009308');
2、DELETE FROM TDEL04 WHERE 同上。
原因堆场明细中有两条记录,只是进入日期不同。