SELECT COUNT(字段name) AS con,字段name,重复字段pc FROM 表名 GROUP BY 重复字段pc HAVING con>=2 转载于:https://www.cnblogs.com/yanchaohui/p/10784340.html