orcale把重复的业务并且未处理的标记

admin

  UPDATE LJBUSAMOUNT la
SET la.STATE = '作废状态'
WHERE la.STATE IS NULL
  AND EXISTS (
    SELECT 1
    FROM LJACCOUNT ac
    WHERE TRIM(la.STOREID) = TRIM(ac.ACCOUNTID)
      AND ac.ORGTYPE = 2
  )

  AND la.SETTLEDATE >= '2025/05/05'
  AND ROWID NOT IN (
    SELECT MIN(la2.ROWID)
    FROM LJBUSAMOUNT la2
    WHERE
      TRIM(la2.STOREID) = TRIM(la.STOREID)
      AND la2.SETTLEDATE = la.SETTLEDATE
      AND la2.MEMO = la.MEMO
      AND la2.AMOUNT = la.AMOUNT
  );