--单字段
SELECT * from
(select (t.memberName + t.argot) as aaa FROM agom t where t.status = 0) b
group by b.aaa
having count(b.aaa) > 1
--多字段
SELECT b.* FROM agom a,(
SELECT memberName,argot
FROM agom
where status = 0
GROUP BY memberName,argot
HAVING COUNT(1)>1
) AS b
WHERE a.argot=b.argot
AND a.memberName=b.memberName