使用oracle 伪列删除表中重复记录： Delete table t where t.rowid!=(select max(t1.rowid) from table1 t1 where t1.name=t.name)