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 (home) (work)
QuestionPeter Zaitsev28 Jul
  • Re: QuestionSasha Pachev28 Jul
    • Re: QuestionMichael Widenius30 Jul