1.暴力做法：
select * into [QPTreasureDB].dbo.[WinLoseScoreInfo2] from [QPTreasureDB].dbo.[WinLoseScoreInfo]
drop table [WinLoseScoreInfo]
select distinct * into [QPTreasureDB].dbo.[WinLoseScoreInfo] from [WinLoseScoreInfo2]
2.如果表中有id字段可以考慮：先根據(jù)指定字段查詢重復(fù)數(shù)據(jù)，然后根據(jù)不為已的id設(shè)置保留數(shù)據(jù)
select UserId, ServerId, DateId, count(*) as [count], @@rowid--, ROW_NUMBER()over(order by UserId, ServerId, DateId)
from QPTreasureDB.dbo.WinLoseScoreInfo
group by UserId, ServerId, DateId
having count(*) > 1;