SQL 去除表中的重复列

发布时间:2014-10-22 19:54:26
来源:分享查询网

--remove duplication delete from a from (select [TweetID]        ,ROW_NUMBER() over (partition by TweetID                            order by TweetID)RowNumber from @tempSinaWeiBo) a where a.RowNumber > 1

返回顶部
查看电脑版