-- 20、查询学生的总成绩并进行排名(不重点)
SELECT s_id,SUM(s_score)'总成绩' FROM score
GROUP BY s_id
ORDER BY SUM(s_score) DESC
20、查询学生的总成绩并进行排名(不重点)
最新推荐文章于 2024-05-08 20:08:44 发布
-- 20、查询学生的总成绩并进行排名(不重点)
SELECT s_id,SUM(s_score)'总成绩' FROM score
GROUP BY s_id
ORDER BY SUM(s_score) DESC