SQL to count the number of instances each time a certian value appears

[Guest_imported]

Hi I have a tbl
that contains a field called admin

This coloum has A unique name that can appear a number of times

What I want to do is return the Nummber of times each name appears and the name

ie

Name time

me 5
you 6
them 5


Many Thanks
paul@formz.co.uk

 

[jimbopalmer]

select name, count(name) from mytable group by name;

is that what you want? I tried to remain child-like, all I acheived was childish.

 

[Guest_imported]

Solved it my self


SELECT ADMIN , COUNT(ADMIN) as times
FROM TBL_XXXXX
GROUP BY ADMIN