86Stang Posted May 29, 2008 Share Posted May 29, 2008 Hi All, I've got a client with a database where there are records with the same email address. They want me to remove any records that have a duplicate email address but I must leave one of those records intact. In other words, I'm wanting to take the table from this: joe@joe.com joe@joe.com joe@joe.com bob@bob.com bob@bob.com to: joe@joe.com bob@bob.com Anyone want to give up some points of wisdom on this? Quote Link to comment Share on other sites More sharing options...
86Stang Posted May 30, 2008 Author Share Posted May 30, 2008 I know you're all dying to answer my question but PLEASE form an orderly line to the left so nobody gets hurt. Quote Link to comment Share on other sites More sharing options...
fenway Posted May 30, 2008 Share Posted May 30, 2008 You could add a UNIQUE idex. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.