摘要： 单主键 with T as( SELECT ROW_NUMBER() over (PARTITION By 工件号 order by 检测时间 desc) as rowid,* FROM 检测表 ) delete from T where id not in( select id from T wh 阅读全文