SELECT *
FROM TABLE_1 A
WHERE A.ROWID != (SELECT MAX(B.ROWID)
FROM TABLE_1 B
WHERE A.字段1 = B.字段1
AND A.字段2 = B.字段2)
建议先建立临时表,然后关联删除。
FROM TABLE_1 A
WHERE A.ROWID != (SELECT MAX(B.ROWID)
FROM TABLE_1 B
WHERE A.字段1 = B.字段1
AND A.字段2 = B.字段2)
建议先建立临时表,然后关联删除。