WITH CTE AS(
SELECT VendorCode ,
RN = ROW_NUMBER()OVER(PARTITION BY VendorCode ORDER BY VendorCode)
FROM inv.navvendormaster
)
--select * from cte WHERE RN > 1
DELETE FROM CTE WHERE RN > 1
SELECT VendorCode ,
RN = ROW_NUMBER()OVER(PARTITION BY VendorCode ORDER BY VendorCode)
FROM inv.navvendormaster
)
--select * from cte WHERE RN > 1
DELETE FROM CTE WHERE RN > 1
No comments:
Post a Comment