sql 怎么删除重复数据只保留一条?时间:2022-04-25 15:02:14 with cte as(select *,row_number() over(partition by id order by id)rn from [chengpinid]) delete cte where rn>1