Re: Counting distinct rows - Mailing list pgsql-novice

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