Oracle 删除重复记录仅保留一条

delete from tabname t1
 where rowid <> (select min(rowid)
                   from tabname  t2
                  where t1.col_name = t2.col_name
                    and t1.id = t2.id);