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?
views:
24answers:
1
+5
A:
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
HAVING COUNT(*) > 1;
mdma
2010-08-13 18:42:59
very nice. beat me to it!
Derek Adair
2010-08-13 18:44:11