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
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
Leave a Reply