SELECT DISTINCT and count

Question

Hello,

the table looks 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

Answer 1

select tag, count(*)
from MyTable
group by tag