A table having duplicate record columns... I need to just show how many duplicate values present in that particular column...not unique values...Only Duplicate values should be displayed?
Asked
Active
Viewed 31 times
-1
-
Possible duplicate of [Finding duplicate values in MySQL](https://stackoverflow.com/questions/688549/finding-duplicate-values-in-mysql) – P.Salmon Sep 25 '19 at 07:47
-
Search for mysql duplicates - lots of stuff out there.. – P.Salmon Sep 25 '19 at 07:47
1 Answers
1
Do a count with groupby, and then filter the ones that have duplicates with having your_count_column > 1
Ilia Gilmijarow
- 1,000
- 9
- 11