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)
Newd
版權聲明
作者:扶我起來我還要敲
地址:http://www.rzrgm.cn/Newd/p/13878713.html
? Newd 尊重知識產權,引用請注出處
廣告位
(虛位以待,如有需要請私信)
浙公網安備 33010602011771號