摘要： delete t from ( select * , row_number() over (order by 重复字段) as rowid from 表名 where 重复字段 in (select 重复字段 from 表名 group by 重复字段 having count( 重复字段)>1) 阅读全文