List:General Discussion« Previous MessageNext Message »
From:Sasha Pachev Date:July 28 1999 7:40pm
Subject:Re: Question
View as plain text  
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)
Thread
QuestionPeter Zaitsev28 Jul
  • Re: QuestionSasha Pachev28 Jul
    • Re: QuestionMichael Widenius30 Jul