Help: a challanege SQL request

From: charles <dshproperty_at_gmail.com>
Date: Tue, 28 Jun 2011 12:50:42 -0700 (PDT)
Message-ID: <ce8be703-c386-42a7-8593-7969990e55e7_at_a31g2000vbt.googlegroups.com>



All,

I have a table like this:
COL1 COL2


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?

Thanks Received on Tue Jun 28 2011 - 14:50:42 CDT

Original text of this message