Oracle删除重复的数据，Oracle数据去重复
摘要：Oracle数据库中查询重复数据：select*fromemployeegroupbyemp_namehavingcount(*)>1;Or...
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);
【Oracle删除重复的数据，Oracle数据去重复】相关文章：
上一篇：
常用Oracle分析函数大全
下一篇：
Oracle对字段的增删改方法分享