delete from tabname t1
where rowid <> (select min(rowid)
from tabname t2
where t1.col_name = t2.col_name
and t1.id = t2.id);
Oracle 删除重复记录仅保留一条
最新推荐文章于 2023-07-07 09:48:06 发布
delete from tabname t1
where rowid <> (select min(rowid)
from tabname t2
where t1.col_name = t2.col_name
and t1.id = t2.id);