List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:September 24 1999 10:56pm
Subject:Re: Counting "Distinct"
View as plain text  
At 3:39 PM -0500 9/24/99, Thomas Miller Hall wrote:
>Is there a way to count the number of "distinct" elements of a certain
>column of a table?

As of MySQL 3.23.2, yes.  You can say COUNT(DISTINCT col_name).

Paul DuBois, paul@stripped
Counting "Distinct"Thomas Miller Hall25 Sep
  • Re: Counting "Distinct"Thimble Smith25 Sep
    • Re: Counting "Distinct"Jani Tolonen26 Sep
  • Re: Counting "Distinct"Paul DuBois25 Sep