查询数据表中重复姓名的信息: select * from user where username in (select username from user group by username having count(username)>1)