例子:
DELETE FROM 表 A WHERE ROWID IN (SELECT ROWID_ FROM (SELECT 字段1, 字段2, ROWID ROWID_, ROW_NUMBER() OVER(PARTITION BY 字段1,字段2 ORDER BY 1) ROW_NUM FROM 表 A) WHERE ROW_NUM > 1);