select id, name, memo
from A
where id in (select id from A group by id having count(1) >= 2)
转载于:https://www.cnblogs.com/yinchengliang/p/4362821.html
select id, name, memo
from A
where id in (select id from A group by id having count(1) >= 2)
转载于:https://www.cnblogs.com/yinchengliang/p/4362821.html