Extracting Data

[jestrada101]

How can i get sets of duplicate data?

For example, I have the following data in a table.

12312 DATA1 DATA2
12323 DATA1 DATA2
33333 DATA3 DATA1
42324 DATA3 DATA1

I'd like to return the matching:
12312 12323
33333 42324

How can I get this in query?

 

[Dagon]

What happens if you have three (or more) duplicates e.g.

12312 DATA1 DATA2
12323 DATA1 DATA2
12324 DATA1 DATA2

What do you expect to see then ? Is this going to return:

12312 12323
12312 12324
12323 12324

Or do you always only have 2 duplicates ?