题解 | #考试分数(三)#

select
    id,
    name,
    score
from
    (
        select
            g.id,
            l.name,
            g.score,
            dense_rank() over (
                partition by
                    g.language_id
                order by
                    g.score
                desc
            ) ranks
        from
            grade g,
            language l
        where
            g.language_id = l.id
    ) t
where ranks <= 2
order by name, score desc, id