SQL：查询重复行

select id, name, memo
from A
where id in (select id from A group by id having count(1) >= 2)

【推广】免费学中医，健康全家人

原文地址：https://www.cnblogs.com/fffywfn/p/5914016.html