WITH [GetDuplicate] AS
(
SELECT RowNum = ROW_NUMBER() OVER (PARTITION BY Name ORDER BY Id DESC),
Name
FROM Employee
)
DELETE FROM [GetDuplicate] WHERE RowNum > 1
You need to be a premium member to use this feature. To access it, you'll have to upgrade your membership.
Become a sharper developer and jumpstart your career.
$0
$
. 00
monthly
For Basic members:
$20
For Premium members:
$45
For Elite members: