select a.* from entest a,(select article_id,users_id from entest group by article_id,users_id having count(*)>1) b where a.users_id=b.users_id and a.article_id=b.article_id
表内容如下:
select a.* from entest a,(select article_id,users_id from entest group by article_id,users_id having count(*)>1) b where a.users_id=b.users_id and a.article_id=b.article_id
表内容如下: