I have a table with many duplicate records:
shop
ID tax_id
1 10
1 10
1 11
2 10
2 12
2 10
2 10
I want to delete all duplicate records without creating a temporary table. After the update query, the table should look like:
shop
ID tax_id
1 10
1 11
2 10
2 12
See Question&Answers more detail:os