删除一个表里面的重复数据且保留ID最小的数据

?

1 2 3 4 5 6 7 8 9 10 11

DELETE FROM     Person WHERE     id IN (     SELECT         id     FROM         ( SELECT id, email, row_number() over ( PARTITION BY email ORDER BY id ) AS rone FROM Person ) a     WHERE     rone > 1)

　　表Person: id,email