sql脚本:
DELETE
FROM
表名
WHERE
ID IN (
SELECT
ID
FROM
(
SELECT
eol.*,
row_number ( ) over ( partition BY eol.重复的字段名 ORDER BY eol.日期字段 DESC ) rn
FROM
表名 eol
WHERE 条件
)
WHERE rn != 1
)
更正,若多列数据每个列值都一样无法通过id区分,则使用下列sql:
DELETE FROM your_table
WHERE ROWID NOT IN (
SELECT MIN(ROWID)
FROM your_table
GROUP BY column1, column2, ..., columnN
);