Finding Duplicates (or records with more than 1 item)

Posted on by

SELECT
DISTINCT id.
COUNT(id)
FROM
my_table
GROUP BY
id
HAVING
COUNT(id) > 1

Leave a Reply