刪除重復記錄,僅留一條
WITH RankedInventory AS ( SELECT *, ROW_NUMBER() OVER ( PARTITION BY StorageLocationId, ProductId ORDER BY (SELECT Id) -- 保留任意一條,或指定排序字段(如主鍵) ) AS RowNum FROM Inventory ) DELETE FROM RankedInventory WHERE RowNum > 1;
WITH RankedInventory AS ( SELECT *, ROW_NUMBER() OVER ( PARTITION BY StorageLocationId, ProductId ORDER BY (SELECT Id) -- 保留任意一條,或指定排序字段(如主鍵) ) AS RowNum FROM Inventory ) DELETE FROM RankedInventory WHERE RowNum > 1;