Comparing Duplicate Records between Columns
Posted on 2006-03-23
I need to run a simple query to produce a comparable results between the columns and need your help. Here is the sample table info:
Column 1 Column 2 Column 3 Column 4
00001111 XXXXX XXXX1 XXXX2
00002222 YYYYY SSSS XXXXX
00003333 ZZZZ SSSS
00004444 SSSS SSSS1
Each row has 4 columns. Column 1 is a unique key so there won't be any duplicate records. Columns 2, 3 and 4 are not unique so we might have the same record from other columns as well. In the sample above, Record "XXXXX" from Row 1, Column 2 is also in Row 2, Column 4. The same thing applies to record "SSSS" where it is in Row 2, Column3, Row 3, Column 4 and Row 4, column 2.
I need to produce a result showing these duplicate records. Database is Oracle 8i, running Windows NT4.