delete 表名 where rowid in (select rowid from ( select t.*,rank()over(partition by 分组列 order by 排序列) rn from 表名 t ) where rn=1 )