List:General Discussion« Previous MessageNext Message »
From:Ferindo Middleton Date:February 12 2008 12:23am
Subject:finding duplicate key
View as plain text  
I have a table (customers) without a primary key. I want to make the
email_address field the primary key, only problem is, several records
already share the same email_address

How do I write a query which will show me all the instances where
email_address is duplicated throughout the table.

--
Ferindo

Thread
finding duplicate keyFerindo Middleton12 Feb
  • Re: finding duplicate keyGrant Limberg12 Feb
    • Re: finding duplicate keyMoon's Father12 Feb