Postgres Pro
Downloads
Home   >   mailing lists

Re: select count of distinct rows - Mailing list pgsql-sql

From Jaime Casanova
Subject Re: select count of distinct rows
Date
Msg-id c2d9e70e0512101712u760f3eb4x3f5b0820233d0530@mail.gmail.com
Whole thread Raw
In response to Re: select count of distinct rows  ("Foster, Stephen" <stephenlfoster@comcast.net>)
Responses Re: select count of distinct rows  ("Foster, Stephen" <stephenlfoster@comcast.net>)
List pgsql-sql
Tree view 
On 12/10/05, Foster, Stephen <stephenlfoster@comcast.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 ;)

pgsql-sql by date:

Previous
From: "Foster, Stephen"
Date:
Subject: Re: select count of distinct rows
Next
From: Jaime Casanova
Date:
Subject: Re: select count of distinct rows