MySQL: Count occurrences of distinct values in a column
What i want to do is : example db id name —– —— 1 Mark 2 Mike 3 Paul 4 Mike 5 Mike 6 John 7 Mark expected result name count —– —– Mike 3 Mark 2 Paul 1 John 1
What i want to do is : example db id name —– —— 1 Mark 2 Mike 3 Paul 4 Mike 5 Mike 6 John 7 Mark expected result name count —– —– Mike 3 Mark 2 Paul 1 John 1