Delete Duplicate Rows in Employees Table

Question

How do I delete duplicate rows in MySQL keeping the lowest id?

Accepted Answer

```sql
DELETE t1 FROM employees t1
INNER JOIN employees t2 
WHERE t1.id > t2.id AND t1.email = t2.email;
```

This query performs a self-join on the "employees" table to identify rows with matching "email" addresses where the "id" of the first instance is greater than the "id" of the second, effectively removing all but the row with the lowest "id".