Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: block a field

Re: block a field

From: David Boyd <davidb158_at_hotmail.com>
Date: Mon, 10 Jul 2006 11:11:26 -0400
Message-ID: <BAY101-F10CD2A0B7E23FE9782A0E8EF6B0@phx.gbl>


Hi List,

I was wondering if a SQL statement is possible for following query.

The name of the table is test. It has following data:

name                        group
Marry                        group A 1-1
Marry                        group B 1-2
Marry                        group dev 1-1
Ann                          group A 2-3
Dave                         group A 2-3
Dave                         group B 4-1
Dave                         group dev 3-2

I want to find out the names that are in the exact same groups as 'Marry'. The number in the group has to be ignored. For the above data, the query should return 'Dave' only since both Marry and Dave are in group A, group B, and group dev.

Thanks for any input advance.

Dave



Donít just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jul 10 2006 - 10:11:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US