Re: DISTINCT and COUNT() SQL Query

[Paul DuBois]

I thought he wanted the number of distinct names, not the number of
instances of each distinct name?


At 2:11 AM +0000 5/1/1999, jkraai wrote:
>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.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/