要?jiǎng)h除 Oracle 數(shù)據(jù)庫表中的重復(fù)值,只保留一個(gè)重復(fù)值,可以使用以下方法:
方法一:使用ROWID
DELETE FROM your_table
WHERE ROWID NOT IN (
SELECT MAX(ROWID)
FROM your_table
GROUP BY column1, column2, ...
);
將 your_table
替換為你的表名,并將 column1, column2, ...
替換為你要基于哪些列進(jìn)行去重的列名。
方法二:使用ROW_NUMBER()
DELETE FROM your_table
WHERE ROWID NOT IN (
SELECT ROWID
FROM (
SELECT ROW_NUMBER() OVER (PARTITION BY column1, column2, ... ORDER BY column1) AS rn
FROM your_table
)
WHERE rn > 1
);
同樣需要將 your_table
替換為你的表名,并將 column1, column2, ...
替換為你要基于哪些列進(jìn)行去重的列名。