How can I delete duplicate rows but only if both fields are equal. For example..
In the table below only One Atlanta record would be deleted because not only does the City Field match but the Foreign Key Matches as well. But Dallas would not be deleted because of the different foreign key.

```
+----+-----------------+----------+
| id | City            |     FK   |
+----+-----------------+----------+
| 1  | Los Angeles     |      2   |
| 2  | Dallas          |      5   |
| 3  | Dallas          |      8   |
| 4  | Atlanta         |      12  |
| 5  | Atlanta         |      12  |
| 6  | New York City   |      31  |
+----+-----------------+----------+

```