Re: Help: a challanege SQL request

From: Robert Klemme <>
Date: Tue, 28 Jun 2011 22:19:27 +0200
Message-ID: <>

On 28.06.2011 21:50, charles wrote:
> All,
> I have a table like this:
> ------------------------------
> I a
> I b
> I c
> II a
> II b
> III a
> III b
> III c
> I would like to get all the col1 that data entry is the same as I.
> So in this case, I has a, b, c, and III has a, b, c as well. I would
> like to get III, but II.
> Could somebody help?

Is this some kind of homework assignment? I would join the table with an inline view which selects all COL2 where COL1 is "I". Group the result by COL1 and select only those having a particular count. Roughly. Note, there is a premise which is needed for this to work properly. Left as exercise... ;-)

Kind regards


remember.guy do |as, often| as.you_can - without end
Received on Tue Jun 28 2011 - 15:19:27 CDT

Original text of this message