oracle删除表中的重复记录

delete from ess_format
where Id in (select Id from ess_format group by Id having count(Id) > 1) and rowid not in (select min(rowid) from  ess_format group by Id having count(Id )>1)

 

注：ess_format是表名，id是判断的依据，即该列不允许重复

实际情况：ess_format表中存在id重复的记录，需要将其中重复的记录清除掉，剩下不重复的，可以用以上语句实现