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>