SQL Delete duplicate rows based on column
To remove duplicate rows, use a CTE and partition using the data you want to check for duplicates to assign a row_number against. Then remove any where the row_number > 1 (removing multiple duplicates)

    --REMOVE DUPLICATES
    WITH CTE AS
    (SELECT ROW_NUMBER() OVER 
(PARTITION BY column_tocheck_duplication_against ORDER BY ( SELECT 0)) RN
    FROM TableName)
    DELETE FROM CTE WHERE RN &gt; 1