목록delete (1)

HAZEL

[SQL : DELETE / 서브쿼리 / INNER JOIN] LeetCode : 196. Delete Duplicate Emails

196. Delete Duplicate Emails >> 문제 Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. +----+------------------+ | Id | Email | +----+------------------+ | 1 | john@example.com | | 2 | bob@example.com | | 3 | john@example.com | +----+------------------+ Id is the primary key column for this table. For example, afte..
DATA ANALYSIS/SQL 2021. 3. 9. 18:27
이전 Prev 1 Next 다음