sql语句查询重复数据

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

posted @ 2015-03-24 14:57  尹成亮  阅读(938)  评论(0)  编辑  收藏  举报