sql查询出一张表里重复的字段

SELECT * FROM lb_users a WHERE (a.nickname) IN  (SELECT nickname FROM lb_users GROUP BY nickname  HAVING COUNT(*) > 1)

2017-12-05 12:24:53

阅读数 332

评论数 0

提示
确定要删除当前文章?
取消 删除
关闭
关闭