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

with cte as(select *,row_number() over(partition by id order by id)rn from [chengpinid])delete cte where rn>1
posted @ 2018-08-25 12:30  感生  阅读(1066)  评论(0)  编辑  收藏  举报