DELETE E
FROM Setting E
INNER JOIN
(
SELECT *,
RANK() OVER(PARTITION BY Name
ORDER BY id) rank
FROM Setting
) T ON E.ID = t.ID
WHERE rank > 1;
DELETE E
FROM Setting E
INNER JOIN
(
SELECT *,
RANK() OVER(PARTITION BY Name
ORDER BY id) rank
FROM Setting
) T ON E.ID = t.ID
WHERE rank > 1;