學海無涯

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;