Tag: database

rencontre cougar saint-étienne 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