//查找重复记录SELECT * FROM 表 GROUP BY goods_name HAVING count(goods_name) >= 2; 转载于:https://www.cnblogs.com/dengyg200891/p/6030519.html