mysql find duplicate pairs code example

Example: find duplicate keys in mysql

SELECT col, COUNT(col) FROM table_name GROUP BY col HAVING COUNT(col) > 1;