SQL:查询重复出现记录

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

原文地址:https://www.cnblogs.com/kino/p/9022372.html