`
berrywu
  • 浏览: 125183 次
  • 性别: Icon_minigender_1
  • 来自: 福建
社区版块
存档分类
最新评论

删除重复的数据

 
阅读更多
delete user1 from t_user user1,(select t1.id from t_user t1,(select username,min(id) as minid from t_user group by username having count(username)>1) t2 where t1.username=t2.username and t1.id<>t2.minid) user2 where user1.id=user2.id 

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics