SQL: Delete Duplicates
Medium
SQL — DML
SQL
DELETE
Subquery
Delete duplicate emails keeping lowest ID.
Constraints
Write standard SQL (MySQL 8.0 compatible).
Examples
Example 1:
Input: 1 a@b.com
2 c@d.com
3 a@b.com
Output:
Example 2:
Input: 1 a@b.com
2 c@d.com
3 a@b.com
Output:
Hints
DELETE with self-join or subquery.
Tests:
Runtime:
Memory:
Test
Input:
Expected:
Got:
Click Run Code to test against sample cases, or Submit to test against all cases.
▲ Console