Question

Find and display duplicate records in MySQL?

Answer 1

The key is to rewrite this query so that it can be used as a subquery.

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