LeetCode:196. Delete Duplicate Emails

LeetCode:196. Delete Duplicate Emails

  Rojer Chen's Blog   8/31/2018 06:00:00 下午    0 comments
RojerChen.2018.08.31 今天在解 LeetCode 196. Delete Duplicate Emails 這題,剛好遇到了問題紀錄一下,以下是這題的題目。 Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id. +----+------------------+ | Id | Email |