有学习地址吗
select * from (
select * max(成绩) over(partition by classno) xx from a where course = 'English') a where grade = xx
select classno,name,grade
from (
select row_number()over(partition by classno order by grade desc)rn,name,classno,grade from STSCORE where course='English'
)temp where rn=1
1min目标场景问卷
立即参与
