sqlserver 清掉工件號重復的數據

  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 where rowid = 1)

with T as( 
                SELECT ROW_NUMBER() over (PARTITION By     MachineCode,Content,CreationTime order by id ) as rowid,* FROM [OperationRecords2021-03-01]   
)
 delete from T where id not in( select id from T where rowid = 1)