SQL面试50题-20
链接:https://zhuanlan.zhihu.com/p/43289968
查询学生的总成绩并进行排名(不重点)
SELECT s_id,SUM(s_score), ROW_NUMBER() OVER (ORDER BY SUM(s_score) DESC) AS ranking FROM Score GROUP BY s_id
链接:https://zhuanlan.zhihu.com/p/43289968
查询学生的总成绩并进行排名(不重点)
SELECT s_id,SUM(s_score), ROW_NUMBER() OVER (ORDER BY SUM(s_score) DESC) AS ranking FROM Score GROUP BY s_id
相关推荐