mysql单个表内去重多个重复的字段

最新推荐文章于 2021-08-16 00:50:17 发布

weixin_30512785

最新推荐文章于 2021-08-16 00:50:17 发布

阅读量372

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/542684416-qq/p/11302517.html

版权

DELETE from quzhou WHERE (doctorName,firstDepartmentName,secondDepartmentName,hospitalName) in   
(SELECT doctorName,firstDepartmentName,secondDepartmentName,hospitalName from (SELECT doctorName,firstDepartmentName,secondDepartmentName,hospitalName FROM quzhou GROUP BY doctorName,firstDepartmentName,secondDepartmentName,hospitalName HAVING COUNT(*)>1) s1)   
AND  
id NOT in (SELECT id from (SELECT id FROM quzhou GROUP BY doctorName,firstDepartmentName,secondDepartmentName,hospitalName HAVING COUNT(*)>1) s2);

查询重复字段：

select * from quzhou 
where (doctorName,hospitalName) in (select doctorName,hospitalName from quzhou group by doctorName,hospitalName having count(*) > 1);

转载于:https://www.cnblogs.com/542684416-qq/p/11302517.html