DELETE FROM PS_GL_ACCT_CD_TBL t1
WHERE EXISTS (SELECT 'x' FROM PS_GL_ACCT_CD_TBL t2
WHERE t2.FDM_HASH = t1.FDM_HASH
AND t2.EFFDT = t1.EFFDT
AND t2.EFF_STATUS = t1.EFF_STATUS
AND t2.ROWID > t1.ROWID);
WHERE EXISTS (SELECT 'x' FROM PS_GL_ACCT_CD_TBL t2
WHERE t2.FDM_HASH = t1.FDM_HASH
AND t2.EFFDT = t1.EFFDT
AND t2.EFF_STATUS = t1.EFF_STATUS
AND t2.ROWID > t1.ROWID);
Comments
Post a Comment