Find duplicate rows MySQL

A nice simple query to find duplicate rows in MySQL:

SELECT COLUMN_NAME, COUNT(*) c FROM TABLE GROUP BY COLUMN_NAME HAVING c > 1;

Credit to the Tin Man