Alex Mathew Alex Mathew - 1 year ago 80
MySQL Question

How to find repeated Rows?

Hi Friends

i am having 75000 row records i need to get how many of them repeated,how can i do that in MySQL Query?

Answer Source

This query will return all duplicate rows, and the number of times they are duplicated

SELECT Col1, Col2,..ColLast, Count(*) As NumDups FROM YourTable
GROUP BY Col1,Col2,...,ColLast
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download