Re: SELECT COUNT(DISTINCT ....

[Paul DuBois]

At 12:02 PM +1100 2000-02-17, Albert Ng wrote:
>Hello All,
>
>    just wondering shouldn't select COUNT(DISTINCT columnX) from tableY;
>work?
>
>I keep getting
>
>ERROR 1064: You have an error in your SQL syntax near 'DISTINCT columnX) from
>tableY' at line 1

Your MySQL is probably older than 3.23.2, when COUNT(DISTINCT) was
introduced.

-- 
Paul DuBois, paul@stripped