Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Identifying pairs as groups
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 - 10:38:34 CST
![]() |
![]() |