select id, name, memo from A where id in (select id from A group by id having count(1) >轿游早磨茄= 2)select id, name, memo from A where id in (select id from A group by id having count(1) >闭雀= 2)