查询表中某字段有重复记录个数

1
2
3
SELECT id,count(id) FROM tableName
GROUP BY id
HAVING COUNT(id)>1
坚持原创技术分享,您的支持将鼓励我继续创作!
0%