mysql查询重复数据
时间：2021-07-01 10:21:17
帮助过：3人阅读
* 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
