|
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
|
