In MySQL you could write a query like the following:
SELECT fieldwithdupes, Count(fieldwithdupes)AS NumOccurances FROM atable WHERE fieldwithdupes IN(SELECT fieldwithdupes FROM atable AS tmp GROUPBY fieldwithdupes HAVING COUNT(*)>1) GROUPBY fieldwithdupes;
This will get you a list of the `fieldwithdupes` in `atable` and the number of times that they are repeated. You could adapt this query to your needs.
"Why is it drug addicts and computer aficionados are both called users?" -Clifford Stoll
The Following User Says Thank You to buggabill For This Useful Post: