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

SELECT * FROM lb_users a WHERE (a.nickname) IN  (SELECT nickname FROM lb_users GROUP BY nickname  HAVING COUNT(*) > 1)
展开阅读全文

没有更多推荐了,返回首页