mysql查询重复数据

* 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查询重复数据

标签：mysql   sel   数据   font   username   code   order   class   sql