select * from xi a where (a.username) in (select username from xi group by username having count(*) > 1)
sql 查出一张表中重复的所有记录数据
原文:http://flyyoung.blog.51cto.com/9170074/1876849