© 1999-2048 dssz.net 粤ICP备11031372号
[Oracle] ORACLE重复记录查询.docxORACLE
说明:1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断 select * from people where peopleId in (select peopleId from people group by peopleId having count (peopleId) > 1) 2、删除表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断,只留有rowid最小的记录 delete from people where peopl<weixin_46075394> 上传 | 大小:14kb