delete from table1
where objectid in (select objectid
from (SELECT objectid,
actualid,
RANK() OVER(PARTITION BY actualid ORDER BY CREATEDATE DESC) r
FROM table1)
where r > 1);
比如在table1表中,主键是objectid,相同的actualid下会有多条数据,现在保留一条最新的,把其他的都删掉