Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group