delete from EM_EXPERT
where MPHONE in (select MPHONE from EM_EXPERT group by MPHONE
having count(MPHONE) > 1)
and rowid not in (select min(rowid) from EM_EXPERT group by MPHONE having count(MPHONE)>1)
orcale删除数据库中重复数据
最新推荐文章于 2024-08-29 11:53:52 发布