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