In MySQL, we could use DISTINCT to choose not to display duplicates and only keep one row of these duplications.
However, now I need to know how many times these rows are duplicated. How would I do it with MySQL SELECT?

Add another question:
Why couldn't I use this statement (it is used in MySQL documentation)

select COUNT(DISTINCT results) from student;

It said syntax error near DISTINCT result)


<Edited by 123finder.com on 12-16-2000 at 08:19 PM>