mysql-查询重复数据

查询表中重复数据，展示出字段内容和count

> select user_name,count(*) as count from user group by user_name having count>1;