Results 1 to 11 of 11
Thread: MySQL - Not Distinct rows
Dec 16, 2000, 20:08 #1
- Join Date
- Aug 2000
- Silicon Valley
- 0 Post(s)
- 0 Thread(s)
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>- Son Nguyen
AdSpeed.com - Ad Serving and Ad Management Made Easy