Remove duplicate worfkflow approvers

 WITH CTE AS (

    SELECT 

        WorkflowProgress_ID,

        Division_ID,

        Country_Code,

        Site_Location,

        AFINumber,

        WorkFlow_ID,

        Approver_userID,

        ROW_NUMBER() OVER (PARTITION BY Division_ID, Country_Code, Site_Location, AFINumber, WorkFlow_ID, Approver_userID ORDER BY WorkflowProgress_ID) AS RowNum

    FROM 

        YourTableName

)

DELETE FROM CTE

WHERE RowNum > 1;