Re: DISTINCT and COUNT() SQL Query

[jkraai]

Drop the distinct:
	SELECT lastname, count(*)
	FROM names 
	GROUP BY lastname
will give you all distinct last names and their counts

--jim

Mike Machado wrote:
> 
> 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