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删除数据库中重复数据
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)
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
扫一扫
