리트코드(LeetCode) SQL - 196. Delete Duplicate Emails
2023. 1. 5. 16:23ㆍ코딩테스트/리트코드(LeetCode) - SQL Study Plan
delete p1 from Person p1,Person p2
where p1.email=p2.email and p1.id>p2.id;
728x90
'코딩테스트 > 리트코드(LeetCode) - SQL Study Plan' 카테고리의 다른 글
| 리트코드(LeetCode) SQL - 1484. Group Sold Products By The Date (1) | 2023.01.05 |
|---|---|
| 리트코드(LeetCode) SQL - 1667. Fix Names in a Table (0) | 2023.01.05 |
| 리트코드(LeetCode) SQL - 1873. Calculate Special Bonus (0) | 2023.01.04 |
| 리트코드(LeetCode) SQL - 183. Customers Who Never Order (0) | 2023.01.04 |
| 리트코드(LeetCode) SQL - 595. Big Countries (0) | 2023.01.04 |