Oracle删除重复的数据，Oracle数据去重复

189 阅读 0 评论 125 点赞

我是靠谱客的博主端庄画笔，这篇文章主要介绍Oracle删除重复的数据，Oracle数据去重复，现在分享给大家，希望可以做个参考。

Oracle 数据库中查询重复数据：

select * from employee group by emp_name having count (*)>1;

Oracle 查询可以删除的重复数据

select t1.* from employee t1 where (t1.emp_name) in (SELECT t2.emp_name from employee t2 group by emp_name having count (*)>1) and t1.emp_id not in (select min(t3.emp_id) from employee t3 group by emp_name having count (*)>1);

Oracle 删除重复数据

delete from employee t1 where (t1.emp_name) in (SELECT t2.emp_name from employee t2 group by emp_name having count (*)>1) and t1.emp_id not in (select min(t3.emp_id) from employee t3 group by emp_name having count (*)>1);