Oracle 删除重复记录

dN)o4p#[q,m4z0

--oracle查找重复记录51Testing软件测试网LE1k R U(I4f8Z(Q?3v
select * from  tableA  a where a.rowid>=(select min(rowid) from tableB b where a.column=b.column) 
Kly3ok+c0[0
%\\ y-jT
i051Testing软件测试网 ]}9[oA-P

--oracle删除重复记录
x2lA^9Q0delete from  tableA  a where a.rowid>=(select min(rowid) from tableB b where a.column=b.column)