SELECT
*,
ROW_NUMBER() OVER(ORDER BY 成绩 DESC) AS 排名
FROM 成绩表