FilesExpand file tree

main

/

196_delete_duplicate_emails.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

15 lines (14 loc) · 263 Bytes

main

/

196_delete_duplicate_emails.sql

Copy path

Top

File metadata and controls

• Code
• Blame

15 lines (14 loc) · 263 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

/*

DELETE

FROM person

WHERE id NOT IN

(SELECT *

FROM (SELECT MIN(id)

FROM person

GROUP BY email) AS t);

*/

DELETE p1

FROM person AS p1,

person AS p2

WHERE p1.email = p2.email

AND p1.id > p2.id;