Find duplicates in MySQL SELECT col1, …

Find duplicates in MySQL

SELECT col1, col2, count(col3)
FROM t1
GROUP BY col1, col2
HAVING count(col3) > 1

Adapted from
http://support.microsoft.com/default.aspx?scid=kb;en-us;139444

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *