duplicate remove

 WITH CTE as(

select *,ROW_NUMBER () over (PARTITION BY User_ID order by Approver_Sequence) as row_num FROM tbl_WorkFlowMembers where 

WorkFlow_ID ='RAILCHLuz00001')

delete from cte

where row_num >1

delete duplicate record

over paritition must be use Order by....