写出删除表中重复记录的语句 oracle.【面试题详解】

今天爱分享给大家带来写出删除表中重复记录的语句 oracle.【面试题详解】,希望能够帮助到大家。



delete from people
where peopleId in (select peopleId from people group by peopleId having
count(peopleId) > 1) and rowid not in (select min(rowid) from people group by

原文链接:https://blog.itblood.com/3150.html,转载请注明出处。
0

站点公告

显示验证码
没有账号?注册  忘记密码?