Re: COUNT(Distinct city) HELP!!!

or u can also try

select count(*)
from
(select distinct city from ct);

Hope this helps
Anand

On Mon, Dec 25, 2000 at 05:27:30PM -0800, Stephan Szabo wrote:
>
>I believe that functionality was added in version 7.0,
>are you using an earlier version?
>
>On Mon, 25 Dec 2000, Abe wrote:
>
>> 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
>>