mysql count rows with a specific column

michael24179

New Member
I have a table like thisSr Name
1       A
2       B
3       C
4       C
5       C
6       E
7       A
8       A
9       A
10       E
11       B
12       B I need output like this
A = 4 Times
B = 3 Times
C = 3 Times
E = 2 Times How can I achieve this?Thanks in advance
 
Back
Top