sql语句查询重复数据

分类: IT文章 • 2025-01-28 10:55:37

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