DELETE FROM 表名 a
WHERE ROWID <> (
SELECT MIN(ROWID)
FROM 表名
WHERE 标识列 = a.标识列
);
Oracle数据去重(不是distinct)
最新推荐文章于 2024-07-16 11:54:08 发布
DELETE FROM 表名 a
WHERE ROWID <> (
SELECT MIN(ROWID)
FROM 表名
WHERE 标识列 = a.标识列
);