https://leetcode.com/problems/delete-duplicate-emails/description/
Delete Duplicate Emails - LeetCode
Delete Duplicate Emails - Table: Person +-------------+---------+ | Column Name | Type | +-------------+---------+ | id | int | | email | varchar | +-------------+---------+ id is the primary key column for this table. Each row of this table contains an em
leetcode.com
|
1
2
3
4
5
6
7
|
# Please write a DELETE statement and DO NOT write a SELECT statement.
# Write your MySQL query statement below
DELETE t1 FROM Person t1
INNER JOIN Person t2
WHERE
t1.id > t2.id AND
t1.email = t2.email
|
cs |
반응형
'python-algorithm' 카테고리의 다른 글
| 백준 27323 長方形 (Rectangle) (0) | 2023.01.31 |
|---|---|
| leetcode 1137. N-th Tribonacci Number (0) | 2023.01.30 |
| leetcode 2433. Find The Original Array of Prefix Xor (0) | 2023.01.27 |
| leetcode 2545. Sort the Students by Their Kth Score (0) | 2023.01.27 |
| leetcode 2396. Strictly Palindromic Number (0) | 2023.01.27 |
댓글