ORACLE删除重复记录

delete from table where rowid not in (select max(rowid) from table group by 字段);