To add to the other excellent replies, a favourite of mine if I want to see how many and which records are duplicate, is to do: ``` SELECT name, COUNT(*) AS cnt, GROUP_CONCAT(person_no) AS nos FROM table GROUP BY name HAVING COUNT(*) > 1 ```
To add to the other excellent replies, a favourite of mine if I want to see how many and which records are duplicate, is to do: ``` SELECT name, COUNT(*) AS cnt, GROUP_CONCAT(person_no) AS nos FROM table GROUP BY name HAVING COUNT(*) > 1 ```