Re: select count of distinct rows

From: Jaime Casanova <systemguards(at)gmail(dot)com>
To: "Foster, Stephen" <stephenlfoster(at)comcast(dot)net>
Cc: Havasvölgyi Ottó <h(dot)otto(at)freemail(dot)hu>, pgsql-sql(at)postgresql(dot)org
Subject: Re: select count of distinct rows
Date: 2005-12-11 01:12:41
Message-ID: c2d9e70e0512101712u760f3eb4x3f5b0820233d0530@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On 12/10/05, Foster, Stephen <stephenlfoster(at)comcast(dot)net> wrote:
> Well this should work but I tried it and it didn't.
>
> SELECT DISTINCT COUNT(*) FROM mytable;
>

No, it shouldn't work... actually is a non-sense, count will return
just one value so there is nothing to be distinct with...

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Foster, Stephen 2005-12-11 01:12:49 Re: select count of distinct rows
Previous Message Havasvölgyi Ottó 2005-12-11 01:07:00 Re: select count of distinct rows