Jump to content

SQL Statement to REMOVE duplicates


mcmuney

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.