I开发者_高级运维 have records in mysql table like
a
a
a
b
b
and I want output like:
a 3
b 2
Is there any mysql query that I achieve that
SELECT field, COUNT(field) FROM table GROUP BY field
I开发者_高级运维 have records in mysql table like
a
a
a
b
b
and I want output like:
a 3
b 2
Is there any mysql query that I achieve that
SELECT field, COUNT(field) FROM table GROUP BY field
精彩评论