List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:May 14 1999 11:16am
Subject:Re: count_distinct?
View as plain text  
unknown@stripped wrote:
> 
> Is there any convenient way to count the unique entries in a table?
> 
> I want to do something like this:
> 
> unique = select count_distinct(*),account,program from data group by
> account,program
> 
> raw = select count(*),account,program from data group by account,program
> 
> ---
> tani hosokawa

Hi Tani

In SQL you can do an:
SELECT COUNT( DISTINCT ... )

But mysql does not yet support this syntax!

Tschau
Christian

Thread
count_distinct?unknown13 May
  • Re: count_distinct?Christian Mack14 May
    • Re: count_distinct?unknown14 May
      • Re: count_distinct?Michael Widenius15 May
        • Re: count_distinct?unknown15 May