mysql查询重复数据 

SELECT * FROM oa_user
WHERE UserName IN (SELECT  UserName  FROM  oa_user  GROUP  BY  UserName  HAVING  COUNT(UserName) >1)
ORDER BY UserName


oa_user表名，UserName需要查重复的字段名

 

posted @ 2018-11-08 14:57  小泉哥  阅读(365)  评论(0)  编辑  收藏  举报