SQL: Find duplicates

Description

To find duplicate entries in your database

Example

SELECT a.firstname, a.lastname, a.address
FROM list a
INNER JOIN list b ON a.address = b.address
WHERE a.id <> b.id