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

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