SQL：查询重复行 

select id, name, memo
from A
where id in (select id from A group by id having count(1) >= 2)
posted @ 2016-09-27 19:39  fffywfn  阅读(135)  评论(0)  编辑  收藏  举报