有如下表:
stu_score表
name object score
a chemistry 75
a physical 66
a english 91
b chemistry 89
b physical 78
b english 62
c english 86
c chemistry 67
c physical 93
----------------------------
要求用1个语句实现以下输出结果:即输出每个object所对应的最高score,同时显示最高score所对应的namename object score
b chemistry 89
c physical 93
a english 91
stu_score表
name object score
a chemistry 75
a physical 66
a english 91
b chemistry 89
b physical 78
b english 62
c english 86
c chemistry 67
c physical 93
----------------------------
要求用1个语句实现以下输出结果:即输出每个object所对应的最高score,同时显示最高score所对应的namename object score
b chemistry 89
c physical 93
a english 91
from stu_score a
where not exists(select 1 from stu_score where name = a.name and score > a.score )