Mysql检索每个省每个市语文成绩最高的学生所有成绩（详细）记录；join on的连接条件可以具有多个，实现检索出group by 后面有多个分组列的语句与非分组语句靠on后的多个条件确定连接在一起；

select*from a join students b on (a.id=b.id and a.price=b.price)

students表的列名如下

studentID	regionID	cityID	ChineseScore	MathScore	EnglishScore	PhysicsScore	chemistryScore	biologyScore

with a as(
select regionID,cityID,max(ChineseScore) from students group by regionID,cityID
)
select * from a join students b on (a.regionID=b.regionIDand a.cityID=b.cityID)

这样就可以将每个省每个市语文成绩最高的学生所有成绩（详细）记录检索出来