牛客SQL练习-74-考试分数(三)

SELECT
	g.id,
	l.NAME,
	g.score 
FROM
	( SELECT *, dense_rank () over ( PARTITION BY language_id ORDER BY score DESC ) AS rank FROM grade ) g,
	LANGUAGE l 
WHERE
	g.language_id = l.id 
	AND g.rank <= 2 
ORDER BY
	l.NAME ASC,
	g.score DESC,
	g.id ASC