일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | 5 | ||
6 | 7 | 8 | 9 | 10 | 11 | 12 |
13 | 14 | 15 | 16 | 17 | 18 | 19 |
20 | 21 | 22 | 23 | 24 | 25 | 26 |
27 | 28 | 29 | 30 | 31 |
Tags
- data_engineer
- Python
- 백준온라인저지
- 백준 온라인 저지
- Pseudo Lab
- 데이터 엔지니어
- telegram
- datacamp
- docker image
- MySQL
- 프로그래머스
- dsf
- 그리디
- docker
- delete join
- Airflow
- Dynamic Programming
- airflow architecture
- leetcode
- docker container
- 알고리즘
- Data Engineering
- BOT
- airflow webserver
- Spark
- terraform
- hackerrank
- 2023년 목표
- 빅데이터를 지탱하는 기술
- SQL
Archives
- Today
- Total
Lim Seunghyun Space
[Leetcode] 196. Delete Duplicate Emails 본문
문제 출처
Delete Duplicate Emails - LeetCode
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
나의 풀이(MySQL)
DELETE P1 FROM Person AS P1
JOIN Person AS P2
ON P1.email = P2.email
WHERE P1.id > P2.id;
728x90
'SQL > SQL 문제' 카테고리의 다른 글
[Leetcode] Exchange Seats (0) | 2023.03.18 |
---|---|
[Leetcode] 197. Rising Temperature (0) | 2022.04.18 |
[Leetcode] 184. Department Highest Salary (0) | 2022.03.25 |
[Leetcode] 183. Customers Who Never Order (0) | 2022.03.23 |
[Leetcode] 182. Duplicate Emails (0) | 2022.03.23 |