用户表:member
按照名字的字段来查找有重复的数据:字段为name
sql:
select * from member where name in (select name from member group by name having count(name)>1)
用户表:member
按照名字的字段来查找有重复的数据:字段为name
sql:
select * from member where name in (select name from member group by name having count(name)>1)
转载于:https://www.cnblogs.com/bigvase/p/6491381.html