SQL 문제 10 - Delete Duplicate Emails LeetCode 196

SQL 문제 10 - Delete Duplicate Emails LeetCode 196 Delete Duplicate Emails 풀이 -- ORACLE, MSSQL DELETE FROM PERSON WHERE ID NOT IN (SELECT MIN(ID) FROM PERSON GROUP BY EMAIL ); -- MYSQL DELETE P FROM PERSON P, PERSON P2 WHERE P.Email = P2.Email AND P.Id > P2.Id mysql에선 delete 시 하위 쿼리의 동일 테이블에서 선택할 수 없기 떄문에 셀프조인을 이용하여 삭제한다. * 출처 Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview. leetcode.com 13.2.2 DELETE Stat...

원문링크 : SQL 문제 10 - Delete Duplicate Emails LeetCode 196