jakebur01 Posted March 25, 2008 Share Posted March 25, 2008 Does anyone know how to update data from one column to another in the same table where there are duplicate rows? Quote Link to comment Share on other sites More sharing options...
Caesar Posted March 25, 2008 Share Posted March 25, 2008 Look into using DISTINCT in your SQL query....but idealy, you want to use some kind of unique identifier in your records...otherwise, makes for crappy work arounds that may be more trouble than they're worth. Good database design is paramount. :-) 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.