List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 1 1999 4:37am
Subject:Re: DISTINCT and COUNT() SQL Query
View as plain text  
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/
Thread
DISTINCT and COUNT() SQL QueryMike Machado1 May
  • Re: DISTINCT and COUNT() SQL Queryjkraai1 May
    • Re: DISTINCT and COUNT() SQL QueryPaul DuBois1 May
  • RE: DISTINCT and COUNT() SQL QueryDon Read1 May
  • Re: DISTINCT and COUNT() SQL QueryMike Machado1 May
    • Re: DISTINCT and COUNT() SQL QueryThimble Smith1 May
  • Re: DISTINCT and COUNT() SQL QueryJim Faucette1 May
  • 3.22.21 RAM Usagejkraai2 May
    • 3.22.21 RAM UsageMichael Widenius2 May
  • Re: 3.22.21 RAM Usagejkraai2 May
  • a problemglen19 May
    • Re: a problem (The table 'SQL134597_0' is full)Pete Harlan20 May
      • Re: a problem (The table 'SQL134597_0' is full)glen20 May
        • Re: a problem (The table 'SQL134597_0' is full)Benjamin Pflugmann21 May
        • Re: a problem (The table 'SQL134597_0' is full)Michael Widenius24 May