Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
How many rows are in the table?
What if there are more than 2 rows that have all 3 columns duplicated? Do you want to retrieve ALL of the duplicates or only those rows that are not the "first" row for a particular set of values (i.e. if 2 rows match, do you want both selected or only 1 - if 3 rows match, do you want all 3 or only 2)?