Oracle 删除重复数据
时间:2022-03-10 17:41
DELETE FROM tb E
WHERE E.ROWID > (SELECT MIN(X.ROWID)
FROM tb X
WHERE X.APR_BSS_ID = E.APR_BSS_ID
AND X.ID=E.ID
AND X.NAME=E.NAME
);
WHERE E.ROWID > (SELECT MIN(X.ROWID)
FROM tb X
WHERE X.APR_BSS_ID = E.APR_BSS_ID
AND X.ID=E.ID
AND X.NAME=E.NAME
);
Oracle 删除重复数据,布布扣,bubuko.com