Re: Counting distinct rows
От
John Taylor
Тема
Re: Counting distinct rows
Дата
Msg-id
02011611172602.02222@splash.hq.jtresponse.co.uk
Ответ на
Re: Counting distinct rows (Einar Karttunen)
Список
Дерево обсуждения
Counting distinct rows John Taylor <postgres@jtresponse.co.uk>
Re: Counting distinct rows Einar Karttunen <ekarttun@cs.helsinki.fi>
Re: Counting distinct rows John Taylor <postgres@jtresponse.co.uk>
Re: Counting distinct rows Steve Crawford <scrawford@pinpointresearch.com>
On Wednesday 16 January 2002 11:03, Einar Karttunen wrote: > On 16.01.02 10:38 +0000(+0000), John Taylor wrote: > > > > Hi, > > > > I'm having problems counting the number of distinct rows in a table. > > > > I've tried the following: > > > > select distinct on(id) count(id) from basketupdates order by id desc; > > > > SELECT count(distinct id) FROM basketupdates; > see http://www.postgresql.org/idocs/index.php?sql-expressions.html > for more information. > Thats it! Thanks JohnT
В списке pgsql-novice по дате отправления
