DELETE FROM fcmi_sys_user a
WHERE ROWID <> (SELECT MIN (ROWID)
FROM fcmi_sys_user b
WHERE a.id = b.id )
删除表中某列重复的数据-Oracle
最新推荐文章于 2023-06-29 14:41:49 发布
DELETE FROM fcmi_sys_user a
WHERE ROWID <> (SELECT MIN (ROWID)
FROM fcmi_sys_user b
WHERE a.id = b.id )