关键是重写此查询，以便可以将其用作子查询。
SELECT firstname, lastname, list.address FROM list INNER JOIN (SELECT address FROM list GROUP BY address HAVING COUNT(id) > 1) dup ON list.address = dup.address;
京公网安备 11010802041100号