DELETE FROM 【表】
WHERE A.ctid = ANY (
ARRAY (
SELECT ctid FROM
( SELECT ROW_NUMBER () OVER (
PARTITION BY
【字段1】,【字段2】,【字段3】,【字段4】 ), ctid
FROM 【表】 ) T
WHERE T.ROW_NUMBER > 1
));
ctid 可改為主鍵
