SELECT DISTINCT and count

Question

the table looks like this:

tag | entryID ----+--------- foo | 1 foo | 2 bar | 3 

And now I want to get all the tags using it:

 foo | 2 bar | 1 

How can i do this?

thanks

Answer 1

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