Re: Question

[Sasha Pachev]

Peter Zaitsev wrote:
> 
> How to find out a number of distinct values of dome coloumn in the table
> 
> count(distinct value) which works in MSSQL does not work in MYSQL
> 
> Any Ideas ?
> 
> Best Regards
>                        Peter Zaitsev

Monty said it should be working already in 3.23.1, but for some reason
it is not - in the mean time, you can do SELECT * FROM table GROUP BY
col_name, and then count how many rows it selects - not very efficient,
but it does the job.

-- 
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)