mysql嵌套查询

select * from(select t.`name` `name`,count(*) count from company t group by t.`name`) aa where aa.count>1;