Hopefully somebody has some thoughts or can point me to a location with information. I have a fairly complex query that ends up with results that are considered duplicate when 4 columns are the same. Each duplicate has a unique PK ID, and I need to get the greatest one. I need that result set to be compared against itself to keep only one of the dupe rows with the max PK_ID. Any thoughts?