Re: [SQL] DISTINCT count(*), possible?

From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
To: rgireyev(at)cnmnetwork(dot)com, pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] DISTINCT count(*), possible?
Date: 1999-06-20 11:40:16
Message-ID: l03130303b392837887c2@[147.233.159.109]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

At 23:08 +0300 on 16/06/1999, Rudy Gireyev wrote:

>
> Out of curiosity, more than anything else.
> Would the group by solve this problem?

No. What you need is the number of groups, not the number of members in
each group, which is what group by provides.

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Thomas Good 1999-06-20 12:47:00 Re: [SQL] DISTINCT count(*), possible?
Previous Message adrian 1999-06-18 23:09:19 Where in the world is pgsql-announce@postgresql.org??