SELECT <column name>, COUNT( <column name> ) AS numOcc
FROM <table>
GROUP BY <column name>
COUNT( <column name>) >1

This is an example of where you have duplicates in one column only.

How to find all the duplicates in my MySQL table

Leave a Reply

Your email address will not be published. Required fields are marked *

+ fifty seven = sixty seven