delete t from
(Select Row_Number() Over(Partition By [name] order by id ) As RowNumberFrom gkx..test2 )t
Where t.RowNumber>1
rank () over ， row_number() over ，rank_dense ()三者区别
http://www.cnblogs.com/lingyuan/archive/2011/02/23/1962129.html
编辑文章 - 博客频道 - youkuaiyun.com
最新推荐文章于 2019-05-26 14:54:09 发布
本文介绍了SQL中的窗口函数delete t from (SelectRow_Number()Over(Partition By [name] order by id) As RowNumber From gkx..test2) t Where t.RowNumber > 1，并对比了rank(), row_number(), rank_dense()三种函数的区别。
From gkx..test2 )t
扫一扫
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
