LeetCode 196: Delete Duplicate Emails
Problem Restatement We are given a table named Person . Schema: Column Type id int email varchar The id column is unique. Some rows may contain duplicate email addresses. We need to delete duplicate rows so that: Every email appears only once. The row with the smallest id is kept. All other duplicate rows are removed. Example table: id email 1 [email protected] 2 [email protected] 3 [email protected] After deletion: id email...