List:General Discussion« Previous MessageNext Message »
From:Chris W Date:October 31 2006 5:40am
Subject:Finding duplicates
View as plain text  
Suppose I have table t with fields k1, k2 and k3 that all make up the 
primary key.  Then I have fields x, y and z.  If fields x, y and z all 
have the same values in more than one row, there is a good chance they 
are duplicate records.  What is the best way to list all of the rows 
where this condition exists?

-- 
Chris W
KE5GIX

"Protect your digital freedom and privacy, eliminate DRM, 
learn more at http://www.defectivebydesign.org/what_is_drm"

Gift Giving Made Easy
Get the gifts you want & 
give the gifts they want
One stop wish list for any gift, 
from anywhere, for any occasion!
http://thewishzone.com

Thread
Finding duplicatesChris W31 Oct
  • Re: Finding duplicatesChris31 Oct
    • Re: Finding duplicatesChris W31 Oct
      • Re: Finding duplicatesChris31 Oct