SELECT <column name>, COUNT( <column name> ) AS numOcc
FROM <table>
GROUP BY <column name>
HAVING (
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 e-mail address will not be published. Required fields are marked *

+ forty six = fifty