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删除数据库中重复数据
本文介绍了一种使用SQL语句从数据库中删除具有多个相同电话号码的专家记录的方法，确保每个电话号码只对应一条唯一记录。
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
