写出删除表中重复记录的语句 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