Postgres Pro
Downloads
Home   >   mailing lists

Re: Counting distinct rows - Mailing list pgsql-novice

From Einar Karttunen
Subject Re: Counting distinct rows
Date
Msg-id 20020116110307.GB28890@shellak.helsinki.fi
Whole thread Raw
In response to Counting distinct rows  (John Taylor <postgres@jtresponse.co.uk>)
Responses Re: Counting distinct rows  (John Taylor <postgres@jtresponse.co.uk>)
List pgsql-novice
Tree view 
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.

- Einar Karttunen

pgsql-novice by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: select !working
Next
From: John Taylor
Date:
Subject: Re: Counting distinct rows