Hey there,
I get this error but I think this is supposed to work:
The table has some duplicates such as Munich I want the number of distinct cities:
abenew=> select * from ct;
name| age| city
---- +--- +------
jow | 10| london
tim | 15| paris
kim | 17| munich
te | 19| munich
(8 rows)
My query is as follows:
tester => select count(distinct city) from ct;
ERROR: parser: parse error at or near "distinct"
Any guidance would be appreciated...
Thanks
Abe