用户表:member
按照名字的字段来查找有重复的数据:字段为name
sql:
select * from member where name in (select name from member group by name having count(name)>1)