有主键的就不用说了,可以通过主键不同进行删除。
无主键的情况下可以用下面的语句
WITH cte
AS ( SELECT * ,
ROW_NUMBER() OVER ( PARTITION BY c1[, c2] ORDER BY pk ) rn
FROM t1
)
DELETE cte
WHERE rn > 1
PARTITION BY 分区; ORDER BY排序