List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 17 2000 1:35am
Subject:Re: SELECT COUNT(DISTINCT ....
View as plain text  
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
Thread
SELECT DISTINCTBob Jerrard17 Feb
  • SELECT COUNT(DISTINCT ....Albert Ng17 Feb
    • Re: SELECT COUNT(DISTINCT ....Paul DuBois17 Feb
  • Re: SELECT DISTINCTThimble Smith17 Feb