with cte as(select *,row_number() over(partition by id order by id)rn from [chengpinid]) delete cte where rn>1