Remove Duplicates from Table

[Description]
You are give a table named Person

Code:  Select all

[Description]You are give a table named PersonCode: Select all+-------------+---------+| Column Name | Type    |+-------------+---------+| email       | varchar || id          | int     |+-------------+---------+id is the primary key column for this table.Write a SQL to delete all the duplicated email records

id is the primary key column for this table.

Write a SQL to delete all the duplicated email records

For example, if the rows are:

For example, if the rows are:+----+-------------+| 1  | [e-mail] || 2  | [e-mail] || 3  | [e-mail] || 4  | [e-mail] |+----+-------------+Does deleting duplicate email records mean deleting all duplicates except the first entry?+----+-------------+| 1  | [e-mail] || 2  | [e-mail] |+----+-------------+Or we don't care if the deleted entry is not the first one, such as this is correct too?+----+-------------+| 3  | [e-mail] || 4  | [e-mail] |+----+-------------+