1、数据库设计
设计.png

2、查询sql

SELECT * FROM test
WHERE
(
name IN (SELECT name FROM test GROUP BY name,age,class HAVING COUNT(*)>1)
AND age IN (SELECT age FROM test GROUP BY name,age,class HAVING COUNT(*)>1)
AND class IN (SELECT class FROM test GROUP BY name,age,class HAVING COUNT(*)>1)
)

3、结果
结果.png

标签: mysql

添加新评论