CREATE TABLE courses(
student VARCHAR(64) NOT NULL,
class VARCHAR(20)
);
INSERT INTO courses VALUES('A','Math');
INSERT INTO courses VALUES('B','English');
INSERT INTO courses VALUES('C','Math');
INSERT INTO courses VALUES('D','Biology');
INSERT INTO courses VALUES('E','Math');
INSERT INTO courses VALUES('F','Computer');
INSERT INTO courses VALUES('G','Math');
INSERT INTO courses VALUES('H','Math');
INSERT INTO courses VALUES('I','Math');
INSERT INTO courses VALUES('A','Math');
SELECT class
FROM courses
GROUP BY class
HAVING COUNT(DISTINCT student)>=5
MySQL
最新推荐文章于 2025-05-28 14:58:38 发布