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需要查重复的字段名
mysql查询重复数据
原文：https://www.cnblogs.com/penghq/p/9929094.html
