delete t1 where rowid in
(
select rowid
from (
select row_Number() over(partition by t1.asset_code order by t1.asset_code) xh,t1.rowid
from t1
) where xh>1
)

 

解释一下，两个知识点：

1，rowid

2， row_Number() over() 函数的用法