Re: Counting distinct rows - Mailing list pgsql-novice

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