xxxxxxxxxx
WITH CTE AS (
SELECT *, ROW_NUMBER() OVER (ORDER BY ID, [Name]) AS RowNum
FROM Product
WHERE CONCAT(ID, ',', [Name]) IN (
SELECT CONCAT(ID, ',', [Name])
FROM Product
GROUP BY ID, [Name]
HAVING COUNT(*) > 1
)
)
DELETE
FROM CTE
WHERE RowNum > 1;
DELETE FROM Customers WHERE ROWID NOT IN (SELECT MAX (rowid) FROM Customers C WHERE CustomerNumber = C.CustomerNumber);