select * from(select t.`name` `name`,count(*) count from company t group by t.`name`) aa where aa.count>1;
转载于:https://www.cnblogs.com/annie118/p/3657067.html
select * from(select t.`name` `name`,count(*) count from company t group by t.`name`) aa where aa.count>1;
转载于:https://www.cnblogs.com/annie118/p/3657067.html