Re: SELECT query

From: "G(dot) Anthony Reina" <reina(at)nsi(dot)edu>
To: Joel Burton <jburton(at)scw(dot)org>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: SELECT query
Date: 2001-03-15 00:43:38
Message-ID: 3AB0103A.A72F80DF@nsi.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Joel Burton wrote:

> On Wed, 14 Mar 2001, G. Anthony Reina wrote:
>
> > I think it would be something like:
> > select distinct subject, arm, rep from circles_proc where rep = (select
> > rep from circles_proc where 5 = count(cycle));
>
> You're heading towards
>
> SELECT distinct subject, arm, rep FROM circles_proc WHERE rep IN
> (SELECT rep FROM circles_proc GROUP BY rep HAVING COUNT(rep)=5);
>

Thanks Joel! That works fine.

-Tony

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Daniel A. Melo 2001-03-15 13:21:49 Initdb error
Previous Message Joel Burton 2001-03-15 00:35:18 Re: SELECT query