Delete with join 761ms


  • 0
    Z
    DELETE Person
    FROM Person
    LEFT JOIN
      (SELECT min(Id) AS Id
       FROM Person
       GROUP BY TRIM(Email)) AS PersonUnique USING (Id)
    WHERE PersonUnique.Id IS NULL
    

Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.