为此,将ORDER BY与GROUP BY子句一起使用。我们首先创建一个带有学生姓名和分数的表格-mysql> create table countRowValueDemo
-> (
-> StudentId int NOT NULL AUTO_INCREMENT PRIMARY KEY,
-> StudentName varchar(20),
-> StudentMathScore int
-> );
以下是使用insert命令在表中插入记录的查询-mysql> insert into countRowValueDemo(StudentName,StudentMathScore) values('Larry',45);
mysql> insert into countRowValueDemo(StudentName,StudentMathScore) values('Mike',56);
mysql> insert into countRowValueDemo(StudentName,StudentMathScore) values('John',60);
mysql> insert into countRowValueDemo(StudentName,StudentMathScore) values('David',40);
mysql> insert into countRowValueDemo(StudentName,StudentMathScore) values('David',70);
mysql> insert into countRowValueDemo(StudentName,StudentMathScore) values('John',80);
mysql> insert in