mcmuney Posted February 20, 2007 Share Posted February 20, 2007 I need a SQL statement that will remove duplicate lines; however, rows will not have exact duplicate match. For example, the id field is unique and won't be a duplicate and also the date field won't be duplicate. So I need to delete all records where everything except id and date fields are duplicates. Thanks. PS. It should not delete all lines, but only the extra lines. Quote Link to comment https://forums.phpfreaks.com/topic/39365-sql-statement-to-remove-duplicates/ Share on other sites More sharing options...
fenway Posted February 20, 2007 Share Posted February 20, 2007 Lines? Do you mean rows? And you'll have to create a "super-column" or hash-equivalent and compare those.... Quote Link to comment https://forums.phpfreaks.com/topic/39365-sql-statement-to-remove-duplicates/#findComment-189878 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.