delete users where ids not in (select min(ids) from users group by userid,username having(count(*)>1 or count(*) =1))delete users where ids not in (select min(ids)
阅读背景：
Sql Server 删除重复记录，只保留一条
来源：互联网
分享到：
