oracle单表重复数据处理

1、查询表中多余的重复记录，重复记录是根据peopleId来判断

select * from people where
    where peopleId in (
select  peopleId from people group by peopleId having count(peopleId)
        )

2、删除表中多余的重复记录，复记录是根据peopleId来判断，只留rowid最小的记录

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

3、查询表中多余的重复记录(多个字段)

select * from  people a where (a.peopleId,a.seq) in (
select  peopleId,seq from people group by peopleId,seq having count(*)>1
    )