如何查找重復(fù)的紀(jì)錄：
SELECT * FROM TABLE_NAME
WHERE ROWID!=(SELECT MAX(ROWID) FROM TABLE_NAME D
WHERE TABLE_NAME.COL1=D.COL1 AND TABLE_NAME.COL2=D.COL2);
如何刪除重復(fù)記錄？
DELETE FROM TABLE_NAME
WHERE ROWID!=(SELECT MAX(ROWID) FROM TABLE_NAME D
WHERE TABLE_NAME.COL1=D.COL1 AND TABLE_NAME.COL2=D.COL2)
posted on 2005-08-12 16:51
Java&Inter 閱讀(268)
評論(0) 編輯 收藏 所屬分類:
數(shù)據(jù)庫技術(shù)