Re: COUNT(Distinct city) HELP!!!
От | Abe |
---|---|
Тема | Re: COUNT(Distinct city) HELP!!! |
Дата | |
Msg-id | 000e01c06f35$567609a0$6500a8c0@win2k обсуждение исходный текст |
Ответ на | COUNT(Distinct city) HELP!!! ("Abe" <abe@fish.tm>) |
Список | pgsql-general |
No Joy, unfortunately - It may well be time to upgrade. Thanks, Abe ----- Original Message ----- From: "Anand Raman" <araman@india-today.com> To: <pgsql-general@postgresql.org> Sent: Tuesday, December 26, 2000 6:43 AM Subject: Re: [GENERAL] 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 > >> >
В списке pgsql-general по дате отправления: