SQL：查询重复出现记录

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

posted @ 2018-05-10 23:26  kino_熊  阅读(306)  评论(0)  编辑  收藏  举报