查询名字重复但不是相同的人的记录

 

select * from c where names in (select names from c group by names having count(names)>1)