- 博客(1)
- 资源 (1)
- 收藏
- 关注
原创 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 748
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人
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 748
TA创建的收藏夹 TA关注的收藏夹
TA关注的人