WITH [GetDuplicate] AS
(
SELECT RowNum = ROW_NUMBER() OVER (PARTITION BY Name ORDER BY Id DESC),
Name
FROM Employee
)
DELETE FROM [GetDuplicate] WHERE RowNum > 1
Loading
WITH [GetDuplicate] AS
(
SELECT RowNum = ROW_NUMBER() OVER (PARTITION BY Name ORDER BY Id DESC),
Name
FROM Employee
)
DELETE FROM [GetDuplicate] WHERE RowNum > 1
Join the conversation! Your thoughts help the community grow.