SELECT 姓名 FROM 表 WHERE 姓名 in(select 姓名 from 表 group by 姓名 having count(*)>1) order by 姓名
select user_fullname,count(user_fullname) from user tgroup by user_fullname
