Re: [GENERAL] COUNT(Distinct city) HELP!!!

2000-12-25 Thread Stephan Szabo
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=>

[GENERAL] COUNT(Distinct city) HELP!!!

2000-12-25 Thread Abe
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| londontim | 15| pariskim |