Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Identifying pairs as groups
Are they a group because they are paired at some point? Are they a group
because the are in the same hundred column series? What is the business
purpose of these numbers?
This really seems more like a class assignment than a business problem.
"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
news:1079973490.55117_at_yasure...
> Charlie Edwards wrote:
>
> > I have the following data that identifies pairs. So 101 and 102 is a
> > pair. But also 101 and 103 make a pair which logically means that 101,
> > 102 and 103 make a group. What I need to do is identify each group
> > along with some surrogate key
> >
> > ID1 ID2
> > --- ---
> > 101 102
> > 101 103
> > 102 101
> > 102 103
> > 103 101
> > 103 102
> > 201 202
> > 202 201
> > 301 302
> > 301 303
> > 301 304
> > 302 301
> > 302 303
> > 302 304
> > 303 301
> > 303 302
> > 303 304
> > 304 301
> > 304 302
> > 304 303
> >
> > but what I want is ...
> >
> > ID GROUP
> > --- -----
> > 101 1
> > 102 1
> > 103 1
> > 201 2
> > 202 2
> > 301 3
> > 302 3
> > 303 3
> > 304 3
> >
> > Can anyone help?
> >
> > TIA
> >
> > CE
>
> Someone might be able to if you could clearly state the rules: Something
> you have not done. Examples are fine ... but rules stated in clear,
> descriptive, declarative sentences, are essential. I have no idea from
> what you've written what exactly defines a pair or a group. I could
> guess ... but that is not sufficient.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Mon Mar 22 2004 - 12:24:26 CST