SELECT DISTINCT and count
the table looks开发者_StackOverflow like this:
tag | entryID
----+---------
foo | 1
foo | 2
bar | 3
And now i want to get all tags with its usage:
foo | 2
bar | 1
How can I do this?
Thank you
select tag, count(*)
from MyTable
group by tag
精彩评论