mysql多个字段(三个)查重记录
1、数据库设计
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、结果