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需要查重复的字段名
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需要查重复的字段名