– 相同数据去重的方案
DELETE FROM st_pptn_r WHERE ROWID IN
(SELECT ROWid FROM (
SELECT row_number() over (partition by stcd,tm order BY tm DESC ) AS num, ROWID FROM st_pptn_r ) a WHERE a.num >1)
– 相同数据去重的方案
DELETE FROM st_pptn_r WHERE ROWID IN
(SELECT ROWid FROM (
SELECT row_number() over (partition by stcd,tm order BY tm DESC ) AS num, ROWID FROM st_pptn_r ) a WHERE a.num >1)