mysql 删除重复手机号_Mysql删除重复的数据

最新推荐文章于 2023-03-31 11:01:00 发布

游外 UWAI

最新推荐文章于 2023-03-31 11:01:00 发布

阅读量183

点赞数

文章标签： mysql 删除重复手机号

本文链接：https://blog.csdn.net/weixin_33274593/article/details/113437980

版权

原标题：Mysql删除重复的数据

MySQL数据库中查询重复数据

Ｓelect * Ｆrom employee group by emp_name having count (*)>1;

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

Ｓelect t1.* Ｆrom employee t1 Ｗhere (t1.emp_name) in (Ｓelect t4.emp_name Ｆrom (Ｓelect t2.emp_name Ｆrom employee t2 group by t2.emp_name having count(*)>1) t4) Ａnd t1.emp_id not in (Ｓelect t5.emp_id Ｆrom (Ｓelect min(t3.emp_id) as emp_id Ｆrom employee t3 group by t3.emp_name having count(*)>1) t5);

Mysql 删除重复的数据

Ｄelete t1 Ｆrom employee t1 Ｗhere (t1.emp_name) in (Ｓelect t4.emp_name Ｆrom (Ｓelect t2.emp_name Ｆrom employee t2 group by t2.emp_name having count(*)>1) t4) Ａnd t1.emp_id not in (Ｓelect t5.emp_id Ｆrom (Ｓelect min(t3.emp_id) as emp_id Ｆrom employee t3 group by t3.emp_name having count(*)>1) t5);

责任编辑：