Oracle ORA-30926

--处理重复记录
SELECT userid FROM t_raugh GROUP BY userid HAVING COUNT(*) > 1;

DELETE t_raugh
WHERE ID IN (SELECT a.ID
FROM (SELECT b.id,
b.userid,
b.operdate,
row_number() over(PARTITION BY b.userid ORDER BY b.operdate DESC) rn
FROM t_raugh b
WHERE b.userid IN (25468911,
25467429,
25464008,
25466351,
25464129,
25464805,
25468403,
25466240,
25467371,
25467777,
25464193,
25468734,
25464215,
25464596,