查找重复记录 （GROUP BY goods_name HAVING count(goods_name) >= 2;） 

//查找重复记录

SELECT * FROM  表  GROUP BY goods_name  HAVING  count(goods_name) >= 2;

 

posted @ 2016-11-04 15:38  Xiao|Deng  阅读(297)  评论(0)  编辑  收藏  举报