Oracle删除重复的记录

获取姓名相同的条数>=2的姓名

select name from Person group by name having count(*)>=2;

获取所有这些姓名的ID

select id from Person where name in (select name from Person group by name having count(*)>=2);

找出重复记录中第一条记录的主键

select min(id) from Person group by name having count(*) >= 2;select min(id), name, count(*) from Person group by name having count(*) >= 2;

删除重复的记录

delete from Person where -- 删除姓名相同数量>=2的数据        id in (select id from Person where name in (                select name from Person group by name having count(*) >= 2))-- 并且不是第一条        and id not in (select min(id) from Person group by name having count(*) >= 2);