Not able to delete using below query.
DELETE FROM I_DTE_LOOKUP_AUDITS A INNER JOIN I_DTE_LOOKUP B ON A.F_AUDIT_KEY = B.F_RECORD_KEY
WHERE A.F_OPERATION_MODE='UPDATED' AND 2 < (SELECT COUNT(1) FROM I_DTE_LOOKUP_AUDITS C
WHERE A.F_AUDIT_KEY = C.F_AUDIT_KEY AND A.F_AUDIT_ID < C.F_AUDIT_ID);