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. 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.... 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
Archived
This topic is now archived and is closed to further replies.