Listing Duplicate Records

Posted on January 2, 2009, under MySQL.

SELECT id, name from names GROUP BY name having COUNT(name) > 1

Leave a Comment

You must be logged in to post a comment.