Something like this should help you find all of the dupes select email_address from table group by email_address having count(*)>1;
On Feb 11, 2008 4:23 PM, Ferindo Middleton <[EMAIL PROTECTED]> wrote: > 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 > -- Grant Limberg [EMAIL PROTECTED]
