196. Delete Duplicate Emails mysql

https://leetcode.com/problems/delete-duplicate-emails/?envType=study-plan&id=sql-i 

Delete Duplicate Emails - LeetCode

delete from person
where id not in (
    select sub.min_id
    from (
        select min(id) as min_id, email
        from person
        group by email) as sub);

서브쿼리부터 어려워서 답지를 봤다.. ㅠ

출처 : https://minni7.tistory.com/23

[LeetCode] 서브쿼리 : 196. Delete Duplicate Emails

 

distinct를 쓰는 게 아닌 것 같아서 group by를 해야하고, group by를 한 컬럼은 반드시 select에 들어가야 하니 또 서브쿼리를 짜야하는 문제..