数据库如何查询姓名重复2次或2次以上的记录

1个回答

SELECT *
FROM class
WHERE name IN (SELECT name FROM class GROUP BY name HAVING COUNT(num) >=2)
即可