删除表中重复数据

删除表中重复数据

 delete from test
    where rowid in (select rowid
                      from (select rowid as rid,
                                   row_number() over(partition by name order by id) as seq
                              from test)
                     where seq > 1);