select n.id, n.name, n.score from ( select g.id, name, score, dense_rank()over(partition by name order by score desc) posn from grade g join language l on g.language_id=l.id )n where n.posn<3
点赞

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务