SELECT 学号, 姓名, SUM(分数) AS 总成绩, DENSE_RANK() OVER (ORDER BY SUM(分数) DESC) AS 排名 FROM 成绩表 GROUP BY 学号, 姓名 ORDER BY 总成绩 DESC;