oracle 查找或删除重复数据

select * from  tableA  a where a.rowid>=(select min(rowid) from tableB b where a.column=b.column) 

delete from  tableA  a where a.rowid>=(select min(rowid) from tableB b where a.column=b.column)