select * from c where names in (select names from c group by names having count(names)>1)
select * from c where names in (select names from c group by names having count(names)>1)
转载于:https://www.cnblogs.com/yinqing/archive/2011/08/24/2152543.html