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

with cte as(select *,row_number() over(partition by id order by id)rn from [chengpinid])
delete cte where rn>1 
展开阅读全文
博主设置当前文章不允许评论。

没有更多推荐了,返回首页