Oracle用rowid删除重复记录
查询:
select *
from org_dept a
where a.rowid !=
(select max(rowid) from org_dept b where a.dept_code = b.dept_code)
删除:
delete
from org_dept a
where a.rowid !=
(select max(rowid) from org_dept b where a.dept_code = b.dept_code)