如何删除重复记录?
DELETE FROM TABLE_NAMEWHERE ROWID!=(SELECT MAX(ROWID) FROM TABLE_NAME DWHERE TABLE_NAME.COL1=D.COL1 AND TABLE_NAME.COL2=D.COL2);
SQL删除重复数据
最新推荐文章于 2022-11-25 15:47:07 发布
如何删除重复记录?
DELETE FROM TABLE_NAMEWHERE ROWID!=(SELECT MAX(ROWID) FROM TABLE_NAME DWHERE TABLE_NAME.COL1=D.COL1 AND TABLE_NAME.COL2=D.COL2);