List:General Discussion« Previous MessageNext Message »
From:jkraai Date:May 1 1999 2:11am
Subject:Re: DISTINCT and COUNT() SQL Query
View as plain text  
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
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