Re: count_distinct?

[Christian Mack]

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