Oracle表中重复数据去重的方法_JAVA_编程开发_程序员俱乐部

class="java">
delete from mytest ms
 where rowid in (select aa.rid
                   from (select rowid as rid,
                                row_number() over(partition by s.name order by s.id) as nu
                           from mytest s) aa
                  where aa.nu > 1)