server1.dk

Tech Tips

SQL: Find duplicate rows

Posted on February 15, 2013 by Henrik

SELECT column,
COUNT(column) AS NumOccurrences
FROM table
GROUP BY column
HAVING ( COUNT(column) > 1 )

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.