SQL help needed
- From: "David Boyd" <davidb158@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 10 Jul 2006 11:17:52 -0400
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
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
//www.freelists.org/webpage/oracle-l
Other related posts: