--查找重復(fù)數(shù)據(jù)

SELECT NODE_ID, BUSI_ID
FROM I_AGENT_BUSI_AMOUNT
WHERE STAT_TIME = 200601
GROUP BY NODE_ID, BUSI_ID
HAVING COUNT(*) > 1


--排重
SELECT *
FROM I_AGENT_BUSI_AMOUNT
WHERE ROWID IN (SELECT RID
FROM (SELECT ROWID RID,
ROW_NUMBER() OVER(PARTITION BY NODE_ID, BUSI_ID ORDER BY ROWID) RN
FROM I_AGENT_BUSI_AMOUNT
WHERE STAT_TIME = 200601)
WHERE RN 1)

轉(zhuǎn)載于:https://www.cnblogs.com/vanuan/archive/2006/02/21/9576175.html

總結(jié)

以上是生活随笔為你收集整理的[Oracle] 数据排重的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。