--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
--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