Mysql 统计数据库重复记录

Sql 语句

select user_id,user_name from users group by user_name having count(user_name) > 1;