题解 | #考试分数(三)#
考试分数(三)
https://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
select
g1.id,
name,
score
from (
select
id,
language_id,
score,
dense_rank() over (partition by language_id order by score desc)
as rank_num
from grade
) as g1
join language
on g1.language_id = language.id
where rank_num <=2
order by name,score desc,g1.id
OPPO公司福利 629人发布
开发你这个也没有项目啊
不是你说是南通我都没往那方面想，人家真是想表达那个意思吗？
投递地平线等公司7个岗位