delete t1 where rowid in(select rowidfrom (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() 函数的用法