Your technology certification is waiting. Enroll in Cloud Class ®
;WITH CTE AS (SELECT T.*,
ROW_NUMBER() OVER ( PARTITION BY <fields that you consider to specify which rows are duplicates> ORDER BY <fields to specify to tell the rownumber to return 1 for the row you want to keep ...> ) RN
FROM yourtable AS T
DELETE CTE WHERE RN > 1
Open in new window
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.