如何删除重复记录?
DELETE FROM TABLE_NAMEWHERE ROWID!=(SELECT MAX(ROWID) FROM TABLE_NAME DWHERE TABLE_NAME.COL1=D.COL1 AND TABLE_NAME.COL2=D.COL2);
SQL删除重复数据
最新推荐文章于 2024-01-22 10:52:17 发布
如何删除重复记录?
DELETE FROM TABLE_NAMEWHERE ROWID!=(SELECT MAX(ROWID) FROM TABLE_NAME DWHERE TABLE_NAME.COL1=D.COL1 AND TABLE_NAME.COL2=D.COL2);