kawayiwy的专栏

转载 Oracle中查询并删除重复记录的SQL语句详解

<br />1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断 <br />　　select * from people<br />　　where peopleId in (select   peopleId from   people group by   peopleId having count(peopleId) > 1)<br />　　2、删除表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断，只留有 rowid最小的记录<br />　　delete f