leetcode

Leetcode submissions
git clone git://git.laack.co/leetcode.git
Log | Files | Refs | README

delete-duplicate-emails.sql (210B)

      1 --Delete the Person P from the Person table
      2 DELETE P
      3 FROM Person P, Person P1
      4 --Deletes when emails are matched and the id of the selected person is greater than the other
      5 WHERE P.email=P1.email AND P.id>P1.id