List:General Discussion« Previous MessageNext Message »
From:Don Read Date:May 1 1999 2:13am
Subject:RE: DISTINCT and COUNT() SQL Query
View as plain text  
On 01-May-99 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.
> 

select distinct lastnames,count(lastname) from whatever group by s

Regards,
---
Don Read                                 sysop@stripped
EDP Manager                                  dread@stripped
Calcasieu Lumber Co.                               Austin TX
-- Meddle not in the affairs of dragons, for you are crunchy and 
      taste good with ketchup.

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