Re: COUNT(DISTINCT some_column)

2001-02-23 Thread Peter Skipworth
Oops...apologies...my mistake =) *blush* P On Fri, 23 Feb 2001, Fred van Engen wrote: > On Fri, Feb 23, 2001 at 08:13:20PM +0900, Sam Joseph wrote: > > > > however on the MySQL versions I currently have access to (3.22.32 & > > 3.22.34) I get this: > > &

Re: COUNT(DISTINCT some_column)

2001-02-23 Thread Fred van Engen
On Fri, Feb 23, 2001 at 08:13:20PM +0900, Sam Joseph wrote: > > however on the MySQL versions I currently have access to (3.22.32 & > 3.22.34) I get this: > > mysql> select COUNT(DISTINCT SOME_COLUMN) from SOME_TABLE; > ERROR 1064: You have an error in your

Re: COUNT(DISTINCT some_column)

2001-02-23 Thread Peter Skipworth
& > 3.22.34) I get this: > > mysql> select COUNT(DISTINCT SOME_COLUMN) from SOME_TABLE; > ERROR 1064: You have an error in your SQL syntax near 'DISTINCT > SOME_COLUMN) from SOME_TABLE' at line 1 > > whereas > > mysql> select COUNT(SOME_COLUMN) from SOME

COUNT(DISTINCT some_column)

2001-02-23 Thread Sam Joseph
results) from student; however on the MySQL versions I currently have access to (3.22.32 & 3.22.34) I get this: mysql> select COUNT(DISTINCT SOME_COLUMN) from SOME_TABLE; ERROR 1064: You have an error in your SQL syntax near 'DISTINCT SOME_COLUMN) from SOME_TABLE' at line 1 whe