196. Delete Duplicate Emails leetcode Solution

preview_player
Показать описание
196. Delete Duplicate Emails leetcode Solution
leetcode sql
******************************

*********************************

*********************************

*******************************

************************************

*******************************************

******************************************

**************************************

***********************************

*******************************

**********************************

**************************************

************************************

***************************************

LeetCode
database
SQL
MySQL
PostgreSQL
interview preparation
coding interview
data structures
algorithms
programming
software engineering
computer science
coding challenge
problem solving
technical interview
database questions
SQL tutorial
database tutorial
coding practice
learn SQL
Рекомендации по теме
Комментарии
Автор























realNameHiddenN
Автор

This will not work now
Try this

delete from Person where id not in(select min(id) from (SELECT * FROM Person) As P1 group by email);

tejasdonadkar
join shbcf.ru