oracle数据库表剔重 Oracle

超简单啊....

 

delete from  zzq a WHERE ROWID>

       (SELECT Min(b.ROWID) FROM zzq b WHERE a.id=b.id);