23.MySQL中的HAVING(分组过滤)

目录

1.准备

2.实例演示

3.HAVING和WHERE的异同

---

1.准备

CREATE DATABASE mahaiwuji;

USE mahaiwuji;

CREATE TABLE student (
	sid INT (4) PRIMARY KEY,
	sname VARCHAR (36),
	course VARCHAR (36),
	score INT,
	grade INT (4)
) ENGINE = INNODB DEFAULT CHARSET = utf8;

INSERT INTO student VALUES (1,'aa','语文',60,1);
INSERT INTO student VALUES (2,'aa','数学',70,1);
INSERT INTO student VALUES (3,'aa','英语',80,1);

INSERT INTO student VALUES (4,'bb','语文',70,1);
INSERT INTO student VALUES (5,'bb','数学',60,1);
INSERT INTO student VALUES (6,'bb','英语',60,1);

INSERT INTO student VALUES (7,'cc','语文',90,2);
INSERT INTO student VALUES (8,'cc','数学',50,2);
INSERT INTO student VALUES (9,'cc','英语',60,2);

INSERT INTO student VALUES (10,'dd','语文',70,2);
INSERT INTO student VALUES (11,'dd','数学