sql 怎么删除重复数据只保留一条？

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

delete cte where rn>1