首页 > 技术文章 > oracle去除重复字段

newlooker 2014-09-10 10:01 原文

delete from 表名 where rowid not in (select min(rowid) from 表名 group by name having count(name)>=1)

代码摘自百度。

推荐阅读