oracle某个字段有重复数据，如何删除多余数据只保留1条
delete from z t where t.rowid not in (select min(rowid) from z t1  where t1.id=t.id  group by id)