删除重复记录，仅留一条

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;