题解 | #考试分数(三)#
考试分数(三)
http://www.nowcoder.com/practice/b83f8b0e7e934d95a56c24f047260d91
-- 求结果排序 SELECT c.id,d.`name`,c.score FROM language d, ( SELECT a.id,a.language_id,a.score,a.number FROM( -- 按排名去top2的language SELECT id,language_id,score,DENSE_RANK() OVER (PARTITION BY language_id ORDER BY score DESC) AS number FROM grade )a WHERE a.number <= 2 )c WHERE c.language_id = d.id ORDER BY d.name,c.score DESC,c.id
腾讯公司福利 674人发布
投递华为等公司8个岗位 >