| 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 key | Ferindo Middleton | 12 Feb |
| • Re: finding duplicate key | Grant Limberg | 12 Feb |
| • Re: finding duplicate key | Moon's Father | 12 Feb |