DISTINCT and COUNT() SQL Query

[Mike Machado]

I am trying to find a query that would select the distinct names in  a
field and return the number. I know select distinct lastname from names
will return the distinct list and have the total at the bottom, but
I would like to use the COUNT() as part of this. Something like select
distinct lastname, count(*) as c from names group by s, but this is not
working. Can anyone come up with a statement to do this? Thanks.

--
Mike Machado
mike@stripped
InnerCite
Network Specialist