玉祥平台客服-15087858732

标题: Oracle删除重复的数据，Oracle数据去重复 [打印本页]

---

作者: 万望    时间: 2020-6-29 07:28
标题: Oracle删除重复的数据，Oracle数据去重复
这篇文章主要介绍了Oracle删除重复的数据，Oracle数据去重复,需要的朋友可以参考下

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

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

复制代码

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

1. 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 删除重复数据

1. 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);

复制代码

---

欢迎光临 玉祥平台客服-15087858732 (http://bbs.delit.cn/)

Powered by Discuz! X3.2