MySQL Duplicate Records Revision as of Sunday, 20 December 2015 at 19:56 UTC 

SELECT      column, COUNT(column) AS column_count 
FROM        table
GROUP BY    column
HAVING      (COUNT(column) > 1)

Category:Nikhil’s Notes
Category:From a past sysadmin
life