;with cte as (select *,row_number()over(partition by 你要设为主键的哪个列 order by 你要设为主键的哪个列) oid from tb) delete from cte where oid>1
http://bbs.csdn.net/topics/390742770
34,587
社区成员
254,588
社区内容
加载中
试试用AI创作助手写篇文章吧