sql dilemna
From: Chris Aiello <caiell02_at_comcast.net>
Date: Sun, 25 Aug 2002 04:06:25 GMT
Message-ID: <5JY99.173360$m91.7528071_at_bin5.nnrp.aus1.giganews.com>
Date: Sun, 25 Aug 2002 04:06:25 GMT
Message-ID: <5JY99.173360$m91.7528071_at_bin5.nnrp.aus1.giganews.com>
I am stumped, although that's not really hard....
Here is my predicament:
I have a table that has 2 columns, column 1 repeats values and column 2 can have any value. Here's an example
col1 col2 1 15 1 35 1 46 1 72 2 10 2 35 2 46 2 11 2 19 2 22 3 15 3 35 3 46 3 72 4 11 4 25
Here's the dilemna...
I need a query that can find distinct col1 values that have matching col2
entries, along with the same number of entries. For example col1 value '1'
has 4 entries with '15','35','46',and '72'. col1 value 2 has the entries
10,35,46,11,19 and 22. value 3 has 15,35,46, and 72. col1 values 1 and 3
have identical corresponding entries...the same values and the same number
of entries. Can anyone help me out with this??
thanks, Chris.
Received on Sun Aug 25 2002 - 06:06:25 CEST