Hi, I have a table with four columns and many rows.
I need to delete the duplicate rows, where the first three column entries are the same, and the fourth column entry is different.
This query shows me what the duplicates are:
select field1,field2,field3,count(*) as cnt from table1 group by field1,field2,field3 having cnt >1;
How can I delete the duplicate rows and keep the original rows?
Thanks a lot.
I need to delete the duplicate rows, where the first three column entries are the same, and the fourth column entry is different.
This query shows me what the duplicates are:
select field1,field2,field3,count(*) as cnt from table1 group by field1,field2,field3 having cnt >1;
How can I delete the duplicate rows and keep the original rows?
Thanks a lot.