题解 | 考试分数(三)
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
select g1.id,name,g1.score
from grade g1
join language l
on g1.language_id= l.id
where(
select count(distinct g2.score)
from grade g2
where g2.score>=g1.score and g1.language_id=g2.language_id
)<=2
order by name,g1.score desc,g1.id
查看10道真题和解析