sql query help

[Crash893]

is it possible to run a count on a column and get the results of each diffrent type of data in the column


I tried playing with count but htat just gives me the total for the column


for example


rob
rob
tim
buddy
rhaps
dog
dog


query returns"
rob =2
tim=1
rhaps=1
bueey=1
dog=2

[jmcilhinney]

SELECT Name, COUNT(Name)
FROM MyTable
GROUP BY Name